Dialogue box Problems

[qurn]

I recently made a search form using the Like ""*" & [Forms]![search]![Text0] & "*" Or Is Null" in the Criteria. Now when I open the querie it opens a dialoge box that say's "enter paramiter value" then it has a little text box to put in the values for the criteria. but I don't want these boxes to come up how can I get rid of these?

 

[Pat Hartman]

Like ""*" & [Forms]![search]![Text0] & "*" Or Is Null"

is invalid. You are missing a field name:

Like ""*" & [Forms]![search]![Text0] & "*" Or SomeField Is Null"

 

[qurn]

just a field name, not a column name?I have tons of fields whitch one should I use, and how can I tell to use that one

 

[boblarson]

field name is the same as column name when talking about a table or query.

As Pat said, you have to be specific when using an OR statement. That means that you will have to specifically state (after the OR) what field or textbox that you want evaluated for NULL.

 

[qurn]

I understand what your saying, but it doesn't seem to work. For example text 8 refers to the Date column. I've tried Or text8 is null, and Or Date is null and I still get the dialogue boxes. Every time I put in anything, it automaticaly put quotatians around it.

 

[boblarson]

Is this a query that you are putting this into?

Can you post the exact syntax you are using? Maybe a screenshot would help.

Also, if you are referencing a field, then you must enclose the field in brackets []. If your field name is DATE, then change it. You should never use a reserved word as a field name, name of object, etc.

 

[Pat Hartman]

Every time I put in anything, it automaticaly put quotatians around it.

This is Access being TOO helpful. Surround you column names with square brackets [] to tell Access that they are not literals and Access will stop surrounding them with quotes.