customizing the find command

[Marguerita]

Hello,

How do I create or customize the find option to first ask
for a first name and then a last name and locate the
desired record?

Thanks
Marguerita

 

[John Vinson]

Hello,

How do I create or customize the find option to first ask
for a first name and then a last name and locate the
desired record?

Thanks
Marguerita

You don't really need a "find command"; a Parameter Query will do this
very nicely.

Simple way: create a Query based on your table with a criterion of

[Enter first name:]

on the criteria line under the FirstName field, and

[Enter last name:] on the LastName.

A bit more sophisticated: use a Form, unbound, with textboxes txtFirst
and txtLast. Use criteria like

=[Forms]![frmCrit]![txtFirst]

Put a button on the Form to open a second form bound to the Query.