filter property of a form

  • Thread starter Thread starter lynn atkinson
  • Start date Start date
L

lynn atkinson

I have a subform based on a query (the query is used
elsewhere) but I want only to display certain records in
this subform. I do not want to put the filter on the query
as it will affect the other forms it appears on. How do I
put a filter on this subform?

I have put the following statement in to the filter
property of the form

((coursesattendedqry.[calc date due]<Date()+30))

But it continues to show all records. What have I done
wrong?
I want the form only to show the courses which are due in
the next 30 days.

Do I have to create a separate query?

thanks
 
Hi,

A form doesn't apply a filter by default, you have to apply it expressly.

You can click Apply Filter on the toolbar, click Apply Filter/Sort on the
Records menu, or use a macro or Visual Basic to set the FilterOn property to
True.

HTH

MFK.
 
Back
Top