Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
COURSE of the MONTH
12 days, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS Access: Subform Referencing Subform
Posted on 2012-12-25
Hello,
I have an MS Access 2007 form with two subforms.
I would like the subform 2 results to be filtered based on the selection in subform 1. I've tried implementing a proposed solution with an unbound text box, but I couldn't get it to work.
Attached is a screenshot explaining what I would like to do, along with a sample database.
It would be great if you could help, then I can implement in my live database.
Cheers.
Access-subform-Question.gif
SBP-Databasev4-dummy.zip
I have an MS Access 2007 form with two subforms.
I would like the subform 2 results to be filtered based on the selection in subform 1. I've tried implementing a proposed solution with an unbound text box, but I couldn't get it to work.
Attached is a screenshot explaining what I would like to do, along with a sample database.
It would be great if you could help, then I can implement in my live database.
Cheers.
Access-subform-Question.gif
SBP-Databasev4-dummy.zip
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
Seems you have wrong child field.
SBP-Databasev4-dummy.zip
SBP-Databasev4-dummy.zip
Active today
Please check this, similar to your request
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27932027.html
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27932027.html
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
AutoNumbers should increment automatically, without duplicates. But sometimes something goes wrong, and the next AutoNumber value is a duplicate. This article shows how to recover from this problem.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month12 days, 15 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.