OnChange question

[JustinB]

I have a combo box [Submitter] that I have a VBA event procedure that updates an unbound text box [EXT] with a value from a different column.

What I've noticed is that when I close the form and reopen, the updated text box goes blank again.

Is there a way to make sure that the text box field [ext] is locked after the initial update based on the combo box?

 

[missinglinq]

If you want the Value of the Textbox to be stored, i.e. to be there when you re-open the Form, it needs to be Bound to a Field in the Underlying Table.

Alternately, you could do your assignment of Value in the Control Source of your Textbox:

=ValueBasedOnComboboxColumn

Linq ;0)>

 

[JustinB]

SOB!! Thanks. I bound the txt box to the combobox and called the correct column. I wish I would have though of that about 5 hours ago.

Thanks again!!

 

[missinglinq]

Better late than never!

Glad we could help!

Linq ;0)>