filtering in a query (1 Viewer)

IanSweet

New member
Local time
Today, 08:26
Joined
Sep 27, 2019
Messages
5
trying to self learn and probably because i don't know what i'm looking for cannot find a solution

hoping someone can point me in the right direction

i have a query and want to be able to filter the results based on user selected filter options, the output is a continuous form with a combo boxes (the combo boxes are populated from a table)
i want to run user selected filter options on several fields within the same query

when i run the query it filters as expected but i need it not to filter if there is no selection made

how do i keep the function
(Criteria field in query)
Forms![Standards View]![CboStatus]

but not filter if there is nothing selected
(or do the same thing in a different way)


Thanks in advance
 

IanSweet

New member
Local time
Today, 08:26
Joined
Sep 27, 2019
Messages
5
see what you mean about looking funky, it did insert an extra is null than needed but once i removed that, Worked a dream

Thank you
:):)
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 08:26
Joined
Aug 30, 2003
Messages
36,125
Happy to help and welcome to the site by the way!
 

Users who are viewing this thread

Top Bottom