Solved Show all record in query (1 Viewer)

theinviter

Registered User.
Local time
Yesterday, 18:49
Joined
Aug 14, 2014
Messages
237
Dear guys
wanna show all record in query if no data selected in combobox.
i tried this but do not know how to do it with NZ.
[Forms]!
  • ![Combo2]
 

CJ_London

Super Moderator
Staff member
Local time
Today, 01:49
Joined
Feb 19, 2013
Messages
16,553
you use OR

somefield=something OR something is null

You might want to spend a moment checking what your post looks like once posted
 

theinviter

Registered User.
Local time
Yesterday, 18:49
Joined
Aug 14, 2014
Messages
237
this i tried
[Forms]!
  • ![Combo2]
 

theinviter

Registered User.
Local time
Yesterday, 18:49
Joined
Aug 14, 2014
Messages
237
sorry i mean to show all record in query if nothing selected in combobox,
form name list
  • [Combo2]
 

CJ_London

Super Moderator
Staff member
Local time
Today, 01:49
Joined
Feb 19, 2013
Messages
16,553
Sorry, don't understand, all you have provided is the name of a control on a form. Don't know the name of the form, don't know what sort of data, don't know what the name of the field(s) are that you want to apply the criteria to, don't know what the rowsource is to your combo, don't knwo which is the bound column.

after 121 posts, you should know by now what you need to provide if you want anything more than a vague answer.
 

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 21:49
Joined
Feb 19, 2002
Messages
42,981
Where (SomeField = Forms!yourform!SomeField OR Forms!yourform!SomeField Is Null)

Surround the expression with () if you need to include additional criteria

Where (SomeField = Forms!yourform!SomeField OR Forms!yourform!SomeField Is Null)
AND (SomeField2 = Forms!yourform!SomeField2 OR Forms!yourform!SomeField2 Is Null)
 

Users who are viewing this thread

Top Bottom