Current Record VBA
Posted on 2004-04-14
I have a subform:
On it I have 2 combo boxes, when choosing something in the first combo box, it generates the list you can choose for the second combo box.
I have on the update procedure of the first combo box (officeID):
RemittanceID is the second combo box, and is requeried to show the list that is generated from the first combo box, like stated above.
This works fine in a single form, however, when I put it in a subform (many form) it requeries all remittanceID combo boxes for that subform hooked to the main form. I just want it to requery the CURRENT RECORD combo box (remittanceID)
Does anyone have a VBA code or idea that will allow me to only requery the current record remittanceID after selecting the OfficeID combo box?
Greatly appreciate the help!!