linking multiple subforms to one main form

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

Guest

Hi
I have access 2000. In the forms wizard, if I get fields from two tables (the main and 1 subform), the wizard will allow me to create the main form and also a subform that is linked with a toggle button. If I get fields from more than 2 tables, the wizard simply puts all the fields on the form and does not create a subform. So, I create the one main form and one sub-form and attempt to add another table as a subform in design view using the subform wizard. The subform wizard will let me create the subform but will not link it with a toggle button. I have five tables that I am attempting to link in a form that will have one main form and 4 sub-forms in the form of toggle buttons. Can someting like this be done

My relationships between the tables are set up as follows

Mailing List (customer number is primary key) - one to many relationship with Pledge, Donor, Volunteer, and Ticket Order tables.
 
Yes it can be done. Simply create the other "subforms" (autoform will work
well). Now copy the Toggle button and once you have renamed them, go to the
code associated with each new button and change the name of the form it is
opening to the correct one.
JoeNC said:
Hi:
I have access 2000. In the forms wizard, if I get fields from two
Click to expand...
tables (the main and 1 subform), the wizard will allow me to create the main
form and also a subform that is linked with a toggle button. If I get
fields from more than 2 tables, the wizard simply puts all the fields on the
form and does not create a subform. So, I create the one main form and one
sub-form and attempt to add another table as a subform in design view using
the subform wizard. The subform wizard will let me create the subform but
will not link it with a toggle button. I have five tables that I am
attempting to link in a form that will have one main form and 4 sub-forms in
the form of toggle buttons. Can someting like this be done?
My relationships between the tables are set up as follows:

Mailing List (customer number is primary key) - one to
Click to expand...
many relationship with Pledge, Donor, Volunteer, and Ticket Order tables.
 
Back
Top