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

Cathy157

New member
Local time
Today, 20:12
Joined
Apr 13, 2022
Messages
2
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
 

Attachments

  • MS_Access_DB_Records_20220413.accdb
    596 KB · Views: 220

Jon

Access World Site Owner
Staff member
Local time
Today, 22:42
Joined
Sep 28, 1999
Messages
7,305
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:42
Joined
May 7, 2009
Messages
19,169
is your db created in A2000?
you might not be able to open the db created on newer version.
 

Gasman

Enthusiastic Amateur
Local time
Today, 22:42
Joined
Sep 21, 2011
Messages
14,048
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:42
Joined
May 7, 2009
Messages
19,169
see this changes on your code.
 

Attachments

  • MS_Access_DB_Records_20220413.accdb
    800 KB · Views: 226

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 22:42
Joined
Jul 9, 2003
Messages
16,245
I see your problem is solved.

Posting this as it may help others:-

 

theDBguy

I’m here to help
Staff member
Local time
Today, 15:42
Joined
Oct 29, 2018
Messages
21,358
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!
 

Users who are viewing this thread

Top Bottom