Multiple combo boxes on a form

[Malt]

I have a form based on two tables. I would like a combo box for a field from
each table that will fill in various fields from the relevant table. Does
anyone have any suggestions?

 

[John W. Vinson]

I have a form based on two tables. I would like a combo box for a field from
each table that will fill in various fields from the relevant table. Does
anyone have any suggestions?

Why would you want to do that?

It sounds like you're trying to store data from one table redundantly into a
second table. This is essentially *never* necessary. You can *display* fields
from the combo's table by including the fields in the combo's row source; put
textboxes on screen with control sources like

=comboboxname.Column(n)

where n is the zero based index of the field. All you need to store is the
foreign key field value from the combo.

John W. Vinson [MVP]

 

[Doris Mullins]

mmmmmm

I have a form based on two tables. I would like a combo box for a field
from
each table that will fill in various fields from the relevant table. Does
anyone have any suggestions?