limiting records on form

  • Thread starter Thread starter papa jonah
  • Start date Start date
P

papa jonah

I have a form used to enter/update over 2000 records. I am currently
wanting to make some changes to those records that only go back to
10/1/2003 (instead of 1992).
How can I tell the form to only look at the needed range instead of
scrolling through 1800 unnecessary records?
 
Base your form on a query that has a WHERE clause along the lines of

WHERE MyDateField > #10/1/2003#

Alternatively, you could set the form's Filter property to

MyDateField > #10/1/2003#
 
I'm not sure how to incorporate the query option.
This is what I currently have for the filter for the data form.

[data].discovery_date>#9/29/2003#

But it doesn't seem to have an effect. Any ideas why?
 
Back
Top