combo filter > no filter? (1 Viewer)

YouMust

Registered User.
Local time
Today, 11:25
Joined
May 4, 2016
Messages
106
Hello i have a form which filters results based on user name,
The user selects their name from a drop down and after update a re query is done.
The drop down just has its own table with users listed and one left blank
This works as it should with this in my query:
[Forms]![frmWOViewer]![Combo]

But! what if the field doesnt have a name in? (ie) blank?
when I select the blank user from the drop down I dont get any results?

How do i list either blank or all ?

On an unrelated note, we could support this forum buy donating?
I'm sure I bought a support thing from here? since the site redesign I cant find it -_-
any links for that?

Thank you for any help
 

CJ_London

Super Moderator
Staff member
Local time
Today, 18:25
Joined
Feb 19, 2013
Messages
16,553
what do you expect the blank value to do? return all user results? if so then your criteria needs to be

=([Forms]![frmWOViewer]![Combo] OR nz([Forms]![frmWOViewer]![Combo],"") ="")
 

YouMust

Registered User.
Local time
Today, 11:25
Joined
May 4, 2016
Messages
106
Hi Cj thanks for you helps

yes when the blank 'user' is selected ALL record's should be displayed even if there isnt a user listed in that field (ie) blank)
[Forms]![frmWOViewer]![Combo] OR nz([Forms]![frmWOViewer]![Combo],"") =""

Works great thanks CJ
 

Users who are viewing this thread

Top Bottom