Updated Lookup menu doesn't display alphabetically

S

sntm

My medical research database involves a lookup menu so that I can enter last
name but it links the data based on unique patient IDs (purpose of design is
to allow elimination of HIPAA-protected name and medical record number once
data collection is complete).

My problem is that when new names are added, they are displayed in the
lookup menu ordered on the unique patient ID (which is sequential) and not
alphabetically by last name.

1) How do I get the lookup menu to display the names alphabetically?

2) Is there a way to keep it from autofilling when there are more than one
possible matches?
(E.g., when I type "Br" it will autofill "Brown" even though there is a
"Bradford", which could lead to major data errors if there are two "Brown"s)
 
J

John Vinson

1) How do I get the lookup menu to display the names alphabetically?
Click to expand...

Base the Combo on a Query which has Ascending on the lastname and
firstname fields.
2) Is there a way to keep it from autofilling when there are more than one
possible matches?
(E.g., when I type "Br" it will autofill "Brown" even though there is a
"Bradford", which could lead to major data errors if there are two "Brown"s)
Click to expand...

Sort as above; typing B will bring up "Baker", typing Br will bring up
Bradford, typing Bro will bring up Brown (or whichever name is first
in the list with the typed substring). You can of course mouse or
arrow down to the desired name if it doesn't jump to it on the first
try.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top