find and verify function

[Guest]

I have a list of about 400 diagnosis that I would like to make available on
one of my forms. A combobox would be ok if the list wasn't so long. What I
would like to do is have a textbox where the user could type part of the
diagnosis and have a "Verify" command button that would work like the "Check
Names" button does in Active Directory. I would of course have to enter all
the diagnosis in a table, but I'm not sure how to go about writing the code
to verify and complete the user's entry in the textbox. Any suggestions?

 

[Steve]

Use a combobox. Go to Properties - Data and set Autoexpand to Yes. Create a
query based on your diagnosis table and sort diagnosis ascending. Use that
query for the rowsource of the combobox.

When a user begins to type in the diagnosis, the combobox list will
automatically scroll to the first diagnosis beginning with the character(s)
the user enters. For example, the user types "M" the list scrolls to the
first diagnosis beginning with M. The user adds "e" so he now has "Me". The
list scrolls to the first diagnosis beginning with Me. The user needs only
to type enough characters until he sees the diagnosis he wants in the list
and then he can click on it.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)