pyromaniac
Registered User.
- Local time
- Yesterday, 23:12
- Joined
- Jun 26, 2015
- Messages
- 30
I have a
so that I get an all option in my dropdown. I also have a
in my query criteria to filter results from the combo box. When all is selected, I get no results. I'm thinking I need an if statement. if all is selected, run this query without the criteria else run query with criteria.
Is there a way to do this in either SQL, macro or VBA?
Code:
UNION SELECT 0, ' All' FROM tblBrands
Code:
[Forms]![frmMain]![cboBrands]
Is there a way to do this in either SQL, macro or VBA?