Help with Filters

[Marks]

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!

[nico5038]

Reading Cascading Combo/List Boxes might give you the right start.

Nic;o)

[Marks]

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.

[Marks]

Finally got there in the end =)

[nico5038]

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 "positionin g combo" and that holds the code with the .Find and .Bookmark.

Nic;o)

[Marks]

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.