Access 2010 -
I have a form, let's call it "Projects" with a subform "status". These are linked to Projects and Status tables in a one to many relationship. Everything is working fine there.
The Projects form has a customer name and a project code text boxes, and if I navigate to different projects, the appropriate status records are available in the subform. I'm trying to get a combo box filter to work. If I put a combo box on the subform, and use the "find a record on my form" wizard. I pick a date value from my status table as what I want to see, since I'm trying to be able to pick from the different status dates for this project. However, when I view the form (by opening the master form, not the sub by itself) I get every single record from the status table, not just the ones that are linked to the displayed project in the main projects form.
I tried going into the row source for the combo box and adding the projects table, then setting a criteria for the project based on forms!projects!project_code. It does give me just one record, but it's just the first record of the query and is not the right filter.
Any thoughts?