customizing the find command

  • Thread starter Thread starter Marguerita
  • Start date Start date
M

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
 
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
Click to expand...

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.
 
Back
Top