altering criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.
I have a form that uses a query as recordsource. What i'm trying to do is
that the query criteria is a value of a textbox. So far so good. The problem
is that i also want to see the data not filtered. I'm trying to use a button
that writes on the TextBox Like "*" Or Is Null to retrieve all the
information. Somehow this doesn't work.

Can anyone help me on this ?

Thanks.

Luis
 
Your WHERE clause should be like:

WHERE MyTextField = Forms!MyForm!MyTextBox
OR Forms!MyForm!MyTextBox IS NULL
 
Back
Top