Lookup Combo Box

[Microsoft]

I have a combo box which I use to lookup names in my database. The Combo is
unbound. When I type a name into my combo box and press enter, as I type the
name I want is autofilled into the combo, but when I press Enter, I am not
taken to that record. I assume I need an event procedure that will run on
After Update, but I'm not sure. What can I do to get the record to go to the
desired record?

 

[Andy G]

Use something like...

Me.RecordsetClone.Findfirst "[YourID] = " & Me![ComboNameHere]
Me.Bookmark = Me.RecordsetClone.Bookmark

Hopefully this will help.

 

[George Nicholson]

http://support.microsoft.com/default.aspx?scid=kb;en-us;287658
Four ways to move to a record from a Combo Box selection

HTH,