Refreshing Form

I have two problems:

1. I have a Form with a subform thats needs to be updated from the Combo boxes on the Main form. When i select the relevant data(Branch_Name, Branch_City) in the combo boxes nothing happens on the sub form(Service Record).

The Combo boxes are called cboBranch_Name and cboBranch_City.

2. The combo boxes Synchronize correctly, but i have to close the form to update the second Combo box(cboBranch_city). If i select another Branch Name in cboBranch_Name, the City's in CboBranch_City are supposed to update, but they don't.

Any assistance with this would be great. Thanks

Requery the second combo on the after update of the first

I have added the following to the after update section of the second combo box.

event procedure: Me! Branch_City.Requery
Me! Branch_City.SetFocus

But the Second combo box(cboBranch_City) still dosen't update from the first Combo Box(cboBranch_Name)?

Me.cboBranch_City.Requery
if that doesn't work, then have you referenced the first combo in Branch_City's underlying query?