Solved Show all record in query

[theinviter]

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]

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]

this i tried
[Forms]!

• ![Combo2]

 

[theinviter]

[Forms]

• [Combo2]

 

[theinviter]

sorry i mean to show all record in query if nothing selected in combobox,
form name list

• [Combo2]

 

[CJ_London]

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]

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)