Auto Populating field based on Combo Box

[John C]

I have a combo box (ID). It has two columns (ID and Model). I want to be
able to chose the ID and have the model auto populate to another feild
(model). After a fair amount of time looking thru the site I have put this
in the code builder:

Private Sub D_AfterUpdate()
Me![Model] = Me.ID.Column(1)
End Sub

Now my problem is that the Model field will not release the value in the
feild when I go to the next record in the form. It also will not store the
value of the model field in the main table. Any help would be great. TIA

 

[Ofer]

Probably the Model field is unbound this why it not storing the value in the
table and this is why the value wont release when you move to the next
record.
Bound it to the Model field in the main table.

 

[John C]

That was it thanks Ofer

Probably the Model field is unbound this why it not storing the value in the
table and this is why the value wont release when you move to the next
record.
Bound it to the Model field in the main table.

I have a combo box (ID). It has two columns (ID and Model). I want to be
able to chose the ID and have the model auto populate to another feild
(model). After a fair amount of time looking thru the site I have put this
in the code builder:

Private Sub D_AfterUpdate()
Me![Model] = Me.ID.Column(1)
End Sub

Now my problem is that the Model field will not release the value in the
feild when I go to the next record in the form. It also will not store the
value of the model field in the main table. Any help would be great. TIA