Filter on selected item in combox if not empty

[Mbakker71]

Hello,



i've a problem with a query. i've a form with multiple comboboxes so that people can search on multiple items. But now i've user the code

Like Nz([Forms]![frm_Searchfile_admin]![cmbDesignator];"*") Or Is Null Or ""

but the problem is when i filter he shows also the records that are empty becase the codes are after the ). does someone known an alternative for this code??

Martijn,
Holland

[June7]

What do you want? You don't want the records with Null to retrieve?

[Mbakker71]

I've a search form with six comboboxes and a listbox. The listbox is connected with a query. that query is filtered on the comboboxes if the user select a row in one of the comboboxes the query is filtert. but now if the user select a row he shows the selected information and the record that are empty.

[June7]

I still don't understand what you want to accomplish. Do you NOT want the 'record that are empty'? If so, then why not just remove the Or Is Null part?

[Mbakker71]

already try it.

then he shows zero records

[June7]

Still not sure what you need. Maybe the following is relevant.

If null is possible in field, must handle. Options:

1. Create fields in query with expression to convert null and apply wildcard filter criteria to that field
[fieldname] & ""
or
Nz([fieldname], "none")

2. Use Or Is Null as part of the criteria parameter (you already tried and say this is not providing the correct output)

[Mbakker71]

I solved the problem

[Mbakker71]

i see now that er is a new problem. he shows none of the empty records

i've made a screenshot

[June7]

Did you try option 1?