Is there something linke ‘ClearAllFilters’ for Combo Box in a Form (1 Viewer)

SachAccess

Active member
Local time
Today, 21:10
Joined
Nov 22, 2021
Messages
389
Hi,
I have a Combo Box in my Form.
This CB allows me to select values from a drop-down option.
My question is, if I select any single value from the drop-down, form shows values for the selected option.
Now how do I go back to all the option without closing and re-opening the form.
I mean is there any clear all filter option available in CB.
I was not able to find it in properties. Can anyone please help me in this.
 

isladogs

MVP / VIP
Local time
Today, 16:40
Joined
Jan 14, 2017
Messages
18,246
No. You need to use code.
Place a small button next to the combo.
Add code to the click event to set the combo value to an empty string (or null as appropriate) then requery the form
 

SachAccess

Active member
Local time
Today, 21:10
Joined
Nov 22, 2021
Messages
389
Hi @isladogs thanks a lot for the help. Have a nice day ahead. :)
 

Users who are viewing this thread

Top Bottom