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
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo