ComboBox - Still struggling

[hdgirl]

I have a combo box that when a member number is selected the form is autopopulated with that members details thefollowing code works fine

Private Sub cboLookUp_AfterUpdate()
Me.RecordsetClone.FindFirst "MembershipNo = " & cboLookUp
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

But when i tab out of the combobox the form go's to the next members details......can anyone help me stop this from happening

CJB

 

[RoyVidar]

Hi!

Your combo is probably the last control to be added to the form, so by tabbing out of it, your'e tabbing to a new record.

One solution could be to go to View | Tab Order in the forms design view, and put the cboLookUp higher on the list.

Roy-Vidar

 

[hdgirl]

Roy

Thanks for that i'd realised that myself while waiting for a response but thanks for replying and its good to know that i can get it right for myself sometimes

Thx

CJB