By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

combo box filter on subform

P: 4
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?
Feb 8 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,488
See what you can do after playing with Cascaded Form Filtering. It should have all you need, but if you still find anything confusing come back and explain (clearly) what that is.
Feb 8 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.