Avatar of cres1121
cres1121
 asked on

Access form is connected to a subform just fine. I would like to connect the subform to other information in a different table. The connection is at the subform level not the form level.

I have a form and a subform that work great.  I would like a record on my subform to call another record that is connected by a linenumber id.  

Can I do something on the subform so my users will know there is data tied to the record?  There could be many records that have no information and I don't want to have  to have them click on it just to check.  

If it does have information on the other table I would like to click on a tab to show the information related to that record.
Microsoft Access* subform

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon
Ryan Chong

can you provide a sample to better illustrate your issue?
cres1121

ASKER
Okay so you click on on opening form... click on okay then type in 17161  then ok, ok and okay.  I took out those fields to make the database smaller.  

Now on the subform double click on contract number which will take you to the detail.  Click on okay, ok, ok, ok, ok, ok, ok,ok till you get the form to respond... so this is where I would like to

From the tblservicelineitem.subform  

Show that line number 12665 has some data from the tblservicelinedetails and if I click on it I would like to open up the data related to this line.  

if there is no data in that table I would like it to open a blank form so we can update it but I would like it to indicate that there is data attached if there is.  So we are not just clicking for the sake of clicking.
Database4.accdb
ASKER CERTIFIED SOLUTION
Gustav Brock

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.
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
cres1121

ASKER
I see you added a Details Exist.... That is perfect.... Where was the code added so I can see the magic underneath so I can get it to work on my database.  If I create a subform to the data how do I get it to open?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Gustav Brock

It's the source query of the subform that I adjusted.

/gustav
cres1121

ASKER
This worked great... It is exactly what I wanted.  I changed my form to be a check box and it looks very cool!

Thank you!
Gustav Brock

You are welcome!

/gustav
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.