In browse mode I have 3 fields (last, first, idnumber).

Is there a way to perform a find on a last name field and have display the results depending on the letters entered. (enter 'r' and display will show all the last names starting with 'r') And keep the format of the table view.

Similar to the typeahead feature but without opening an edit box?

I need to view all the fields of adjacent records at the same time to compare/analyze the data. Then the selected record will become highlighted.

Thank you in advance.

Edited January 22, 200619 yr by Guest

you may need an extra field that calculates the first letter of the last name. Then Use this new field for your searches. The calculation may look something like this:

LastNameInitial = Left (LastName,1)

Would this be the [color:blue]New "Auto complete using previously entered values" (i.e. Excel fashion).

UPDATE. Your suggestions really got me going in the right direction. Thanks. Here is a better description of my issue:

This is to print a registration badge for people when they walk up to the desk. There information is already in the database.

Using the fewest number of keystrokes/clicks find a record by entering just the last initial (or 2) of their last name. Then found set is displayed (browse mode-with all related fields)and when a radio button is pressed the record is selected and printed.

There are many different people with the same first and last name hence the reason to display all of their data to correctly select person. If I concatonate all of the fields and use the edit box/typeahead feature, the data is in a popup and awkward to scroll through.

Is there a better way to do this other than my way:

1. Enter first initial into a field in the header.

2. Find and display in the body of the form script pauses until record is selected.

3. loop back to input field for the next name.

Thanks again folks.