Help with an <All> option in Combo Box to display all records or a Clear 'Categories' button

[Cathy157]

Good Day:

I haven't used MS Access since 2000 so I now consider myself a "newbie". I have spent far too much time working on my database and hoping someone can assist. I am attempting to create an <All> option in my Combo Box (cboCategoryID) to allow users to display all records OR a Clear Filters button (cmdReset) that will reset the Category previously selected. Currently, when I filter by Category, I am unable to view all records unless I close and reopen my form. Attached is my draft DB. I would be most grateful for your time and help! Cathy

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[arnelgp]

is your db created in A2000?
you might not be able to open the db created on newer version.

 

[Gasman]

Clear Filters would be the easiest, that is what I use.
Just set FilterOn to False or to be safe set Filter to "" as well.

 

[arnelgp]

see this changes on your code.

 

[Cathy157]

see this changes on your code.

This is exactly what I was looking for!!! You have no idea how much I appreciate this!!!!! You are a rock star!
Also, thank you to the other individuals for taking time to respond. I am in awe.....

 

[Uncle Gizmo]

I see your problem is solved.

Posting this as it may help others:-

Combo Filter < All> or Some - Nifty Access

Combo Filtering You can set this up yourself by following the instructions below, or you can study the example file which can be downloaded from the Nifty Digital downloads site for a few dollars.. will normally appear as the first entry in your list because the angle bracket puts it at the...

www.niftyaccess.com

 

[theDBguy]

Hi @Cathy157. Welcome to AWF!

I have moved your thread out of the Introduction Forum. You can still post an introduction, if you like. Cheers!