Dynmaic Query

[zambrtp]

I am trying to create a dynamic Query....
I create a query with this criteria [Forms]![Formname]![txtboxname] OR LIKE [Forms]![Formname]![txtboxname]iS NULL, I set the parameters to match the query.
BUT it wont work correctly....
A command button to calls the form with the txtboxes then the a cmd button calls the query...then when I try to view the SQL it says its to large
HELP NEED urgently

 

[zambrtp]

MGM:

Does that allow Nulls...I want to be able to have the user Just enter 2 out of ten and have the query work? and if they dont select anything everything should come back...

thanks for the help
Tereza

 

[mgmslate]

Set enabled to no on your text box and use a check box to enable them. If the text box is not enabled then all records will return. Use a msgbox to warn user if the check box is yes and the text box is null.

Mike