Query Question

[Eric]

Is there a way to display the results of a query in a
form? I have a form which allows users to input data for
parameters for the query, but the results always display
in Datasheet View.

Also, I designed the query to use the following code:

Like "*" & Forms![My_Form]![My_Box] & "*" Or Forms!_
[My_Form]![My_Box} is Null

for around 20 criteria boxes. I keep getting an error
message saying that the code is too complex to view in
design mode. I would like to make some changes to it and
would like to do so without having to recreate the query
from scratch. Any thoughts? Thanks in advance!
Eric

 

[StCyrM]

Hi Eric

Try your code like this:

Like "*" & Forms![My_Form]![My_Box] & "*" Or IsNull(Forms!_
[My_Form]![My_Box}