Is there something linke ‘ClearAllFilters’ for Combo Box in a Form

SachAccess

Active member
Local time
Tomorrow, 02:57
Joined
Nov 22, 2021
Messages
410
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.
 
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
 
Hi @isladogs thanks a lot for the help. Have a nice day ahead. :)
 

Users who are viewing this thread

Back
Top Bottom