I am trying to enter custom names in a combo box and have it go to that customer after it is updated. The combo box has a row source which is a query that lists all the customers as either Last, First or First Last.
I can't get the after up date to work properly. I have using the below after update. Any idea how I can get it to work?
Private Sub cbo_ContactFind_AfterUpdate()
.FindFirst "[CustomerID] = " & Me.cbo_ContactFind
If .NoMatch = False Then
Me.Bookmark = .Bookmark
MsgBox "Contact not found!"