britesynth
Registered User.
- Local time
- Tomorrow, 04:35
- Joined
- Mar 11, 2013
- Messages
- 88
I know this is commonly asked, tried looking online but I couldn't get it to work
how do I use 2 combo boxes to filter a query in a form(datasheet)?
for now I'm stuck with this
SELECT qryClients.ClientID, qryClients.FileAs, qryClients.GroupTag, qryClients.SchoolName, qryClients.SchoolAddress, qryClients.Level, qryClients.ClientState
FROM qryClients
WHERE (((qryClients.GroupTag)=[Forms]![frmClientList]![cboGroupTag])) OR ((([Forms]![frmClientList]![cboGroupTag]) Is Null));
(Then I placed a cmd button which will set the property of cboGroupTag to blank = shows up all the records)
I want to add another combo box to filter qryClients.ClientState after qryClients.GroupTag had been filtered
so I can filter each client according to their Group and then filter the clients who are active/inactive
tried one online, something like - WHERE ([field] = cbo or is null AND [field2] = cbo2 or is null)
it didn't work for me, found a video but it's all about vba
thanks in advance
-jake
how do I use 2 combo boxes to filter a query in a form(datasheet)?
for now I'm stuck with this
SELECT qryClients.ClientID, qryClients.FileAs, qryClients.GroupTag, qryClients.SchoolName, qryClients.SchoolAddress, qryClients.Level, qryClients.ClientState
FROM qryClients
WHERE (((qryClients.GroupTag)=[Forms]![frmClientList]![cboGroupTag])) OR ((([Forms]![frmClientList]![cboGroupTag]) Is Null));
(Then I placed a cmd button which will set the property of cboGroupTag to blank = shows up all the records)
I want to add another combo box to filter qryClients.ClientState after qryClients.GroupTag had been filtered
so I can filter each client according to their Group and then filter the clients who are active/inactive
tried one online, something like - WHERE ([field] = cbo or is null AND [field2] = cbo2 or is null)
it didn't work for me, found a video but it's all about vba
thanks in advance
-jake