Find a record in a form

J

Jwebb

While creating a form for several people to use... I am
trying to allow them to find a record (by a delivery
number). What is the best way to set it up (ie. Marco,
short cut key)
TFTH,
Jay
 
I

ianalexh

a few ways i've found for this same purpose:

1) use the wizard to make a combo box that finds a record. your user can
type in a value or select one from a pull-down list

2) direct or teach your users to use filters (or even create a button on
your form that points to a filter). the filter by form option is great
because it allows your user to type in as much or as little information as
they want in order to find a specific record.

3) sometimes flipping through records is fastest when it comes to forms
(esp. if they're sorted out by some specific criteria). depending on the
size of the form, page up/page down or alternatively ctrl+page up/ctrl+page
down works great. to me that can sometimes be easier esp. in conjuction with
the navigation buttons even if there are many many records.

be interested to know if this helps.

-ih
 
Top