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?

Thanks!

Chris
cansevinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbizupCommented:
Are you looking for instructions on creating a mainform-subform relationship?  Look at this tutorial:

http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx

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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mbizupCommented:
Take a look at this thread, the sample database and the solution posted by BBlu in this question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27512608.html

This is a great example of Parent-child forms, and side by side subforms with one subform controlling the other.
0
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...

;-)

JeffCoachman
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.