Multiple tables to one form

C

Cyberwolf

OK, I know I have done this in the past, and it is driving me crazy. I have
4 different tables that will need to be accessed via one form. in this I
mean I will have a switchboard type form with 4 check boxes, and based on
which check box is checked it will open the underlying form with the
appropriate table.
 
K

Klatuu

Do you have a command button on the switchboard that opens the form(s)?
If you do, in the Click event of the button, before you open the form:

forms!MyFormNameHere.RecorSource = "MyTableOrQueryNameHere"
 
Top