combo box on tab form

[plgii]

I have a tabbed form and on tab one there is a combo box to autofill address, city, state and zip fields when user selects from combo. I use the:

Me.address = Me.Combo108.Column(1) etc...to populate the fields..no problem until I get to the 2nd tab and I want to use the same combo box copied to this tab but once selection is made there I want it to autofill:

Me.address1= Me.Combo108.Column(1)...this will work the first time, but if I say oops I meant this other choice from the combo and reselect that choice, it will not change the fields with reselected data...not sure if I am making sense...I try to requery or refresh and it does not update, but if I go back to the 1st tab and reselect from combo "same choice or different choice" and then go back to the 2nd tab and either reselect from combo again OR then refresh, the fields are then updated. I would think that since I am writing to different fields on the same table that this should not happen. Can anyone give insight on this?

 

[boblarson]

In the AFTER UPDATE event of your first combo box, put

Me.Your2ndComboBoxNameHere.Requery

But, the rowsource of the 2nd combo box needs to have the criteria of the first combo box listed in the query that is the underlying rowsource.