Lookup Combo Box

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

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?
 
Use something like...

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

Hopefully this will help.
 
Back
Top