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
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