Connecting Form

Bare with me, I am not real good with access.

I have three forms... one main form and two smaller ones. The smaller ones are hooked up in relationships of one-to-many.

I want to accomplish two things:

1.) Have the two smaller form be subforms of the main form where I can tab over to them.

2.) If I only open a smaller form, easily link data to the main form it goes with.

Any ideas, maybe links that show me how to do it?


Who is Participating?
mbizupConnect With a Mentor Commented:
Are you looking for instructions on creating a mainform-subform relationship?  Look at this tutorial:

Or are you trying to create form where one of the subforms is dependent on the mainform, and the second subform is controlled by the first subform?

You'd follow the same procedure for this setup, except when linking the second subform, you would point to the ID field in the first subform.

ie:  The first subform would have master-child links like this:

Master:   IDField
Child:      IDField

and the second subform like this:

Master:  Forms!YourFormName!Subform1.LinkingField
Child:     LinkingField
mbizupConnect With a Mentor Commented:
Take a look at this thread, the sample database and the solution posted by BBlu in this question:

This is a great example of Parent-child forms, and side by side subforms with one subform controlling the other.
Jeffrey CoachmanMIS LiasonCommented:
Also know that your table design is unknown here.

<Bare with me, I am not real good with access.>

So you may want to post another question regarding the purpose of this database, and post the details of the tables (Fields, Keys, Relationships, ..etc)

A common mistake with many new Access developers is that they try to create forms first. Not realizing that their table design is not optimal for what they are trying to accomplish...


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.