I have a form that a Combo Box (Originator_Broker) and Text Box (Cas Number). The combo box contains the Originator Name and when one is selected it populates the Cas Number in the text box. This works fine on the form but, when a record is saved, in the Table the data in the Combo Box is visible however the Text Box field in the table is blank.
How can I save the Value of the Text Box as well?
Any help is greatly appreciated!!
tblOriginator_Broker has two fields [b]Originator_Name [/b]and [b]Cas_ID[/b]
combobox is [b]Originator_Broker[/b]
Here is my code:
[code]Private Sub Originator_Broker_AfterUpdate()
Me!Cas_Number = Me!Originator_Broker.Column(1)