Multiple tables to one form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 
This worked great. Thanks.

Klatuu said:
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"
Click to expand...
 
Back
Top