Using a Form to Search for a Record


graphics/05inf16.jpg

graphics/one_icon.jpg

With any record in the form displayed onscreen, click in the field on which you want to search (in this example, the Last Name field).

graphics/two_icon.jpg

Open the Edit menu and choose Find .

graphics/three_icon.jpg

The Find and Replace dialog box opens. Type the entry you want to find (here, Mohr ).

graphics/four_icon.jpg

The field selected in step 1 is displayed in the Look in text box. To instead search the entire form, click the down arrow next to the text box and choose the form's name in the list that appears.

INTRODUCTION

Just like you can search for a record in a datasheet, you can also search in a form. Doing so can help you quickly locate a certain record or set of records. You might search to display a record for editing, or to review a record before making a sales call. You can search on any of the fields in the form.

TIP

Using the Find Button and Shortcut Key

If you prefer, you can click the Find button on the Standard toolbar in the main Access window rather than use the Edit menu to open the Find and Replace dialog box. Alternatively, you can press the Find shortcut ( Ctrl+F ) key on your keyboard.

graphics/05inf17.jpg

graphics/five_icon.jpg

Click the down arrow next to the Match field and select to view matches to the whole field, any part of the field, or the start of the field.

graphics/six_icon.jpg

To match the case as you've entered it, check the Match Case check box.

graphics/seven_icon.jpg

Click Find Next .

graphics/eight_icon.jpg

Access displays the first matching record, with the matching entry highlighted. To view the next matching record, click Find Next ; when you're finished searching, click Cancel .

TIP

Moving the Dialog Box

You may need to move the Find and Replace dialog box to view the matches. Click and drag the dialog box's title bar to move the dialog box out of the way.

TIP

Continuing the Search

If the first match isn't the one you want, you can click the Find Next button in the Find and Replace dialog box until you find the record you need.

TIP

No Matches Found ?

Access displays an alert message to notify you if no matches are found. If that happens, try changing the search options; perhaps the search is too limiting. Alternatively, try searching on a different field, or on the entire table.



Easy Microsoft Office Access 2003
Easy Microsoft Office Access 2003
ISBN: 789729598
EAN: N/A
Year: 2003
Pages: 174

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net