criteria (1 Viewer)

[DT]

I'm trying set the query criteria from a textbox on a form. It's a Status field in the query. 1 = Open, 2 = Closed. If I set the criteria to "1" it shows all open, "2" and it shows all closed and "1" or "2" it shows all. The problem I'm having is setting these in the form. I've set the query to pull the value from the form. I can get the Open or Closed to work but not the All. My textbox shows exactly how the criteria should read "1" or "2" but doesn't show any results. Does this make sense?

Thanks

 

[pbaldy]

I'd probably use this method and leave the textbox empty for all:

http://access.mvps.org/access/queries/qry0001.htm

 

[DT]

Perfect!!!...didn't know that was an option.

 

[pbaldy]

Happy to help!