Changing query criteria

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

Guest

I have a form w/ a subform. The subform has a query for data that uses the
Date() function to only return todays records. On the main form is a
checkbox which when checked, returns the records for todays date. Unchecked;
returns all recrods. But iti doesn't work. I used an iif(checkbox, Date(),
=<Date()) in the criteria field. I also tried a requery w/o results. I am
not getting any records which is correct because there are no todays records.
But get the same results for checked/unchecked.
Any ideas.

Mike
 
Back
Top