RE: finding records faster with list box--how do i do it?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a ready-made Access application with a very powerful QBF (Query by
Form) search form, that is tailer made for your needs. I'm willing to share a
copy with you, if you send me a private e-mail message with a valid reply
address. My e-mail address is available at the bottom of the contributor's
page indicated below. Please do not post your e-mail address (or mine) to a
newsgroup reply. Doing so will only attract the unwanted attention of
spammers.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

"police officer in small town" wrote:

I have an Access database that is growing too large/too fast. I currently
move thru the form by scrolling the records one at a time, but it's too slow.


The table/form is a simple identity database: last name, first name, birth
date, etc. I need a list box/combo box (or whatever would be best) on the
form to show a list of the names that are in the database/table, then let the
user choose that name and go directly to the record. For example, I
currently start at the first letter of the last name of the person, "Adams",
and have to do a lot of clicking one-by-one to get to the records that start
with "Smith". There is no data entry connected to this, just to be able to
see the total record.

I am VERY new at this, so any directions should be simple, clear and
specific. I've read thru posts looking for something similar, but can find
final resolution.
.