Criteria Question

[puforee]

I have a query that has criteria for a field referenced to a selection Form.....[Forms]![Employee By Supervisor frm]![Combo4]...and it works.

Question...I want this criteria use the current criteria (above)or, if [Combo4] is blank I want it to return all records base on the rest of the query.

I have done this before but can't remember how I did it.

Help please for this forgetful person.

 

[HarleyQuinn]

I'd have a look into the Nz() function.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

In the criteria cell of the field:
=[Forms]![Employee By Supervisor frm]![Combo4] OR [Forms]![Employee By Supervisor frm]![Combo4] IS NULL

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[puforee]

PVS....thanks very much. I don't recognize that this is what I used before but...I works perfect.

Have a wonderful day.

:-D :-D :-D