Search Form

[wisni1rr]

Hello,

I have a form named [Search] it has several unbound textboxes with the name property set to this method[qfield] each textbox default value is "".

I have a button that will open a report once clicked. The report RecordSource is a query [qrySearch].

The query has several fields each with this Criteria:

Like [Forms]![Search].[qfield] & "*"[

My problem is if a value in a record is null, it does not return in my search. I need it to return records with nulls as long as all the other requirements are met.

How do I have my query include records with null values if no other criteria is set?

Thanks for any help/advice you can provide!

[NeoPa]

It doesn't help that you left out the field name from your example, but essentially you can use :

Nz([FieldName], '') Like [Forms]![Search]![QField] & '*'

PS. Dot (.) references are not recognised in SQL, or by inference, filters etc (which are also SQL).

[wisni1rr]

Solved!!!

Thanks bunches, NeoPa!

[NeoPa]

Always pleased to help :-)