P
plgii via AccessMonster.com
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?
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?