Automatic Query for every change in record

[GT_engineer]

I have a form that keeps tracks of jobs. On the form there is a combo box for customer numbers. Beside the combo box there is a list box that displays the name(s) of the customer with that number. The query attached to the list box works fine, whenever I change the value in the combo box it updates properly. Below is the VBC

Private Sub cmbPartner_AfterUpdate()
Me.lstPartnerNameID.Requery
End Sub

Private Sub cmbPartner_Change()
Me.lstPartnerNameID.Requery
End Sub

The problem is when i go through all my records in form view the partner name is not updating. It only updates when i update/change the value in the combo box manually. Is there a way for the query to re-query itself automatically when the record changes???

any help will be great, thanks

 

[Beetle]

Requery the List Box in the Current event of the Form.

 

[GT_engineer]

Beetle,

thanks that worked like a charm