Added Combo Box doesn't enter into table

[Guest]

AFTERAfter creating a form based on a table 1, I needed to add a combo box
based on records in table 2.

When selecting records from the combo box, I need the entry to dump into
table 1....

Thanks

 

[Jeff L]

The control source of your combo box needs to be a field in Table 1.
You set that by right clicking the combo box, select Properties, and
assign the field in your table that you want to store the value in
Control Source.

Hope that helps!

 

[Guest]

Andy,

Also keep in mind that the field in table 1 should correspond in type to the
primary key of table 2, even though it may *display* more meaningful text.

Sprinks