another question... I have creat

[pmbryant]

another question...

I have created a database containing all employees phone extensions, positions etc...i have it set up so users can search number by either first_name or surname...

the question is: What do i need to do to allow a user to begin typing someones name and letting the query fill out the rest of the name...this is because some users dont know how to spell certain names and it'll give them the option to select the names as they become available...

eg: if you type, PA , it will show all names that start with PA and so on


i hope this is enough info for some genuis to solve...

a thankyou in advance to the one that helps me...

 

[braindead2]

If I understand correctly what you are trying to do!

IF this is a combobox where you are having them type then just make sure the auto expand property is set to yes.

if you are doing a query based on the data they enter then use a wild card in the criteria
"where [first_name] = '" & me.text1 & "*'"