Opening Forms Faster

  • Thread starter Thread starter Gibson
  • Start date Start date
G

Gibson

Using the following code to open a form whose source is pulled from a table
by a query.
stDocName = "frm1"
DoCmd.OpenForm stDocName, , , stLinkCriteria

How can I use criteria to open the form to the most recent record, first or
last record or even a specific record? I'm just trying to avoid running the
query and returning all records thus speeding up the opening of the form.
 
Include filter criteria with your Docmd.OpenForm statement. YMMV though
based on the design of the form and your app. For example, if you have
combos, listboxes, or subforms with a large number of entries the
performance improvement filtering the main form might be negligible.
 
Back
Top