Combo Box Autofill

[Guest]

I have a combo box based off a table where the user and choose the Entity and
the List is another table tbl_Entity, column #1 being the Entity number
(Autonum) and Column #2 is the name.

I am trying to get text boxes in various areas of the form (a tabbed form)
to display what the user has entered, so the information does not have to be
chosen again.

I can do this for the ID, but not the name.

Please help!
Thanks.

 

[John Vinson]

I have a combo box based off a table where the user and choose the Entity and
the List is another table tbl_Entity, column #1 being the Entity number
(Autonum) and Column #2 is the name.

I am trying to get text boxes in various areas of the form (a tabbed form)
to display what the user has entered, so the information does not have to be
chosen again.

I can do this for the ID, but not the name.

Please help!
Thanks.

That's rather vague, Chickalina. Your combo box has and entity number
(which I'd suggest should be in a width zero field in the combo so
it's not displayed) and a name. So the combo should display the name
(or can be set to do so).

Evidently there is some other information that you want to display in
"various areas", but you do not say what information, or where it
might be coming from.

Care to give us a hand here?

John W. Vinson[MVP]