Solved Leaving comboboxes empty in a form.

[knoet]

I have a form with 3 comboboxes to build a query.
It must be possible to leave 1 or 2 comboboxes empty.
I am using a function like this,this works fine for the first 2 comboboxes.
When I do the same for the 3th combobox nothing works anymore.

Like Nz([Forms]![frmSearch]![txtStatusinfo]; "*")

Any Suggestions.

 

[arnelgp]

what is the 3rd combo/field type?
does your Locale separator is ;

 

[knoet]

The locale separator is ;.
It seems that the field type isn't correct
I'll come back to it.
Thanks for the hint.

 

[knoet]

Changing the field type solved the problem.
Great job.

 

[knoet]

Tested your suggestion Pat, works like a charm.