Best Way to Filter A Form on Opening

[batowl]

Hi All,

I have a database with over 4000 records in it. I do not want my data entry staff presented with all of those records when they are simply entering new data into the system through a form. What is the best way to have the data entry form open up for them with only records from 2014 or later visible? I was going to have them open the form by pushing a macro button so would the best approach be to build an expression in the Where Condition section of the macro builder?

[June7]

If you don't want any capability for this form to present older records, try setting the form RecordSource to a query that has criteria to filter records by current year or current year -1.

Could also try setting the Filter property of form and FilterOnLoad to yes - again filter criteria as already described. This will actually allow the filter criteria to be changed programmatically so earlier records could be viewed.

[CJ_London]

if they are simply entering new data and do not need to see the existing records, set the forms dataentry property to true