B
Bill H.
I set a default value for a combo box when a change is made to the combo
box. The idea being that when the form is opened again, the combo box will
have the last value selected.
Problem is, it don't work! It always "remembers" the first one I selected
after manually clearing out the default value, but when it puts one it, it
never remembers.
huh?
This is what I have:
Private Sub Site_Select_Combo_AfterUpdate()
Me!Site_Select_Combo.DefaultValue = Me!Site_Select_Combo.Column(0)
End Sub
Do I somehow have to tell the form to "save" this default value?
box. The idea being that when the form is opened again, the combo box will
have the last value selected.
Problem is, it don't work! It always "remembers" the first one I selected
after manually clearing out the default value, but when it puts one it, it
never remembers.
huh?
This is what I have:
Private Sub Site_Select_Combo_AfterUpdate()
Me!Site_Select_Combo.DefaultValue = Me!Site_Select_Combo.Column(0)
End Sub
Do I somehow have to tell the form to "save" this default value?