Applyfiter function

  • Thread starter Thread starter iain
  • Start date Start date
I

iain

Thanks for the previous help. Im trying to get a filter sorted now. Again in
a for i have a button whose event opens a query. I want the event then to
apply a filter to the date due field. The filter is to filter for all dates
past todays. I am haveing trouble doing this.

Thanks again
 
Iain,

You don't need to "apply a filter" for this. You can include it right
in the Criteria of the Date Due field in the query. The expression
would be:
Date()
Click to expand...

However, I am not sure about this "open a query". If you mean you are
displaying a query datasheet, then this would generally be regarded as
not a good idea. Maybe base a form on the query, and open the form instead.
 
Back
Top