autolookup

[sunshine076]

I hope that I am in the right area for this question. I have a table of employees that has been turned into a form. My question is is there a way to set up the field that will allow you to begin typing the employees last name and automatically take you to that particular record?

 

[pbaldy]

Have you tried the combo box wizard, choosing the third option, "Find a record..."?

 

[sunshine076]

I know of that way to do it but I was hoping that there was an automatic way where you start typing the last name of an employee and it would automatically go to that record. I can use the command box though if I cannot do it the way I want to.

 

[pbaldy]

The problem with that is that different records will match as the user types. I think it would be pretty distracting if the record kept jumping as they type. The combo can filter as you type, so they could simply hit enter when they're on the name they want.

 

[sunshine076]

Ok, I was still hoping it was a request from my supervisor but hey I do agree with you that your way would be wiser and easier.

 

[pbaldy]

Well, you can do it with this type of thing in the change event (air code warning):

Me.RecordSource = "SELECT * FROM TableName WHERE LastName Like '*" & Me.ComboName.Text & "*'"

But I wouldn't filter the form that way. You could have a listbox underneath that filtered as you typed like that, which I think work work visually better.

 

[sunshine076]

I have decided to keep it how I have it. If the auditor wants to view the name of an employee then they can use the search command option. Thanks for your help.