Microsoft Access 2010 Bible

(Rick Simeone) #1

Part IV: Professional Database Development


896


I showed you several different filtering and searching techniques for bound Access forms. Each
bound Access form includes a RecordsetClone property that references the set of records
bound to the form. You saw how a recordset’s FindFirst method and Bookmark property work
together to locate and display data selected by the user.

You also reviewed the process of building parameter queries that include the parameter as part of
the query’s design, and another example where the parameter references a control on a dialog box.

The techniques described in this chapter greatly extend the utility of Access forms and empower
users to quickly look up data without having to learn the built-in filtering and searching features of
Access forms.
Free download pdf