Avatar of cansevin
cansevin asked on

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
Microsoft Access

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
mbizup

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
mbizup

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jeffrey Coachman

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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy