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

Help with Filters

P: 21
Ok Guys,

Was hoping if you could help me. I want to create a drop down filter in Access Forms.

This names and fields are just examples.


I basically want drop down menu 1 to show the field name "city" for all the records in that table. This will filter drop down menu 2 to show all customers who are based in the city that drop down menu 1 shows. Drop down menu 2 can then open up the record as a form for that customer.

Hope that makes sense, no idea where to begin any ideas anyone?

Many Thanks!
May 20 '08 #1
Share this Question
Share on Google+
5 Replies


nico5038
Expert 2.5K+
P: 3,072
Reading Cascading Combo/List Boxes might give you the right start.

Nic;o)
May 20 '08 #2

P: 21
Cheers for that. I've got 2 drop down's to do filters however how do I get it to link to go to that specific record?

Cheers.
May 20 '08 #3

P: 21
Finally got there in the end =)
May 20 '08 #4

nico5038
Expert 2.5K+
P: 3,072
Well done !
For the positioning you could use the code Access generates "behind" a "Find" combobox. When defineing a new combobox, the wirzard allows with choice 3 to have a "positioning combo" and that holds the code with the .Find and .Bookmark.

Nic;o)
May 21 '08 #5

P: 21
I've generated this code and used a Query to help filter through 2 combo boxes.If I want to insert a "All" option which would display All in the combobox? Is there a way i can load the query which does the filtering if the dropdown value is now all or remove the query if the value is all.

Cheers.
Jun 18 '08 #6

Post your reply

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