Populate other databases through a form

**jPhoenix** · 01-14-2012, 01:02 PM

I have four tables (One; Two; Three & Four). A main form lets the user enter informaion into tbl One. All 4 tables have a field called OrderID (regular number). Once I enter the OrderID into tbl One through the main form, I'd like it to populate the OrderID field into one of the remaining 3 tables (depending on which CheckBox the user checks). After all data is then entered into that subform, close all and go back to the main form for the next new record. BTW - I'm very very new at this.

**June7** · 01-14-2012, 05:04 PM

Without knowing more about your data structure, difficult to advise, but you probably need a form/subform arrangement. This is basic Access functionality. Search Access Help for guidelines on creating forms.

Populate other databases through a form

Thread Tools

Populate other databases through a form

Similar Threads

Auto Populate a new record from a form with data from the current form

Pre populate a second form

Use Combo Box to Populate Form

Two databases, One Form

Populate a field in one form from combobox in another form

Posting Permissions