Query Question

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
Hi Eric

Try your code like this:

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