Multiple tables to one form

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.
 
G

Guest

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"
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Two Tables Using One Form Contents 0
One form for Many Tables 4
Update 2 tables via Check Box in Form 1
Two tables for One form 3
Tab Form with multiple forms 9
Access Switchboard error message 1
How to use multiple command button to copy user form data to multiple worksheet 0
Query to check for values in multiple tables 4

Top