Combo box update field in a different table

[deadringer86]

Hello,



Trying to set up a combo box on a main form to allow me to update a field in a table OTHER than the record source of the form. I have the following set up...

MainTable
MainTable2
AppType

MainTable and MainTable2 are linked one-to-one by EvID (number). They function essentially as two master tables, as the original MainTable reached the limit of relationships available to other tables. MainTable2 is basically overflow from MainTable.

My form is built on MainTable. I need a combo box to look up values in the table AppType (contains fields AppTypeID and AppTypeDescription), show AppTypeDescription in the combo box on the MainTable form, and update a field in MainTable2. The field in MainTable2 should store the number AppTypeID.

Any help would be greatly appreciated!

[RuralGuy]

Why can't you join MainTable and MainTable2 in a query and make that query the RecordSource of the Form?

[deadringer86]

Why can't you join MainTable and MainTable2 in a query and make that query the RecordSource of the Form?

Outstanding idea. I'm self-taught and relatively new to Access, so that never would have occurred to me. I set it up as you suggested and it works perfectly. Thank you very much!

[RuralGuy]

Excellent! Glad we could help.