Don't need the whole table in continuous form on form load
Posted on 2013-11-10
Using Access 2013
I am using a continuous form that loads up a table with several thousand records.
In practice, the user never needs to see all the records at once. They will access the form and enter criteria in the appropriate textboxes above the related fields. The contents of these textboxes are used to build criteria for a filter to display record(s).
Nothing new here, I'm sure.
When the form is accessed, the record source for the form is the entire table. I know that this is not optimal.
I could create an filter that would result in no records displayed when the form is accessed first. When the user enters search criteria, that filter would be replaced by the filter created by the user. My gut tells me that this is an incorrect approach.
I would appreciate some advice.