Query not returning Null Data

[cegbuna]

I have a dilemma! I created a query that is run from a form. There are 5 different indexed search criteria for users to search for data. When I run a search parameter that has a null value, the query returns nothing. Is there a way to fix this so that every data is displayed regardless of a Null values, when the query is run. Here is the example of my query for just one search parameter:

Like [Forms]![frmName].[parameter1] & "*" OR [Forms].[frmName].[parameter1] Is Null

I appreciate any help I can get.

 

[Trevor G]

Change your criteria string to this and it will return what you want.

Like "*" & [Forms]![frmName]![parameter1] & "*"