using a combo box to populate fields then save

[crazy1701d]

I am using a combo box to populate other fields on a form.using =combo.column() to do this. Everytnig fills the form just great But when I go to save it it only saves one field.

I am usig the =combo.column() in the control source area which is where it usualy has the column it would save to. So from this I get that it just doesn't know where to save the data in those other fields.

So my question is....How do I get it to know where to save these fields or is there another way to use a combobox to populate the other fields?

What I am trying to do is pull up people and their info from one db and then pull up activities from another db and then put them into a third db so that i can querry that db later on.



Thank you for any help.

[pbaldy]

You would populate textboxes bound to the table in the after update event of the combo:

Me.BoundTextboxName = Me.ComboName.Column(x)

[crazy1701d]

yes after doing a little more reading that is the solution that I came up with which does what I needed done. I thank you for your reply and help. The other will work for just the showing of info.

Now on to the next task. lol