MS Access: Subform Referencing Subform

dabug80
dabug80 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Seems you have wrong child field.
SBP-Databasev4-dummy.zip
MASEE Solution Guide - Technical Dept Head
Most Valuable Expert 2017

Commented:

Author

Commented:
Thanks for your help. Wrong child reference in subform 2.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial