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, 04: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: 112

Jon

Access World Site Owner
Staff member
Local time
Today, 07:42
Joined
Sep 28, 1999
Messages
5,909
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
Today, 14:42
Joined
May 7, 2009
Messages
16,408
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, 07:42
Joined
Sep 21, 2011
Messages
10,555
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
Today, 14:42
Joined
May 7, 2009
Messages
16,408
see this changes on your code.
 

Attachments

  • MS_Access_DB_Records_20220413.accdb
    800 KB · Views: 100

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 23:42
Joined
Oct 29, 2018
Messages
18,987
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