AfterUpdate on a combo box

[VANMAN]

Here is a bit of code for the AFTERUPDATE on a combo box. This works ok but It does not show the selected item in the combo box window
Sub FindEmployee_AfterUpdate()
Me.RecordsetClone.FindFirst "[EmployeeId] = " & Me!FindEmployee
If Me.RecordsetClone.EOF Then
Else
Me.Bookmark = Me.RecordsetClone.Bookmark
End If
End Sub

It uses the ID to find the record set and I want to show the Employer Name. The Form query pulls all the employer IDs and Names.

 

[jagilman]

I copied your code into a sample and it works. But I dont think I understand your question. Do you want the combo box to display somthing different, or is your form not moving to the right record??

John A. Gilman
gms@uslink.net