synchronizing combo boxes in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anyway to synchronize combo boxes in a subform? I've done it on a form before, but it doesn't seem to work in a subform. I have one combo box where the user selects a location, then when they click on the second combo box it needs to query for only the matching locations. It actually works fine on the first record in the subform, but as soon as the user picks a different location it stops working. Help!!

Thanks!
 
It might be that the second combo box is not requeried. Add this code to the
AfterUpdate event for the first combo box.

Private Sub [1st Combo Box Name]_AfterUpdate()
Me![2nd Combo Box Name].Requery
End Sub

Con Giacomini

Amy said:
Is there anyway to synchronize combo boxes in a subform? I've done it on
Click to expand...
a form before, but it doesn't seem to work in a subform. I have one combo
box where the user selects a location, then when they click on the second
combo box it needs to query for only the matching locations. It actually
works fine on the first record in the subform, but as soon as the user picks
a different location it stops working. Help!!
 
Back
Top