Requery object

[MarkD]

I have the following properties set for an object.



Private Sub Combo18_Exit(Cancel As Integer)
If IsNull(Me.Combo18) Then
Me.Combo18 = [Forms]![frmServiceDocketing]![SpecialistID]
Me.Combo18.Requery
End If
End Sub

When I leave the field blank and press tab, Combo18 is populated with the SpecialistID however, I have to press the tab key a second time to move to the next field on the form. What do I need to do to only have to press tab once, execute the requery and automatically move to the next field?

[ItsMe]

You could try the GotFocus or Enter events instead of the exit. You would then just add a .Setfocus in the afterupdate of the combobox.

Another option may be to place your code in the form's current event. I don't know if that suits your needs though.