Link to home
Create AccountLog in
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
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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