linking multiple subforms to one main form


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

Advertisements

N

news.east.earthlink.net

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

Advertisements


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

Top