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.