Automatic Query for every change in record

GT_engineer

Registered User.
Local time
Today, 03:20
Joined
Aug 23, 2012
Messages
85
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
 
Requery the List Box in the Current event of the Form.
 
Beetle,

thanks that worked like a charm
 

Users who are viewing this thread

Back
Top Bottom