field equal to a value selected in a combo box

[Guest]

See below:
I have set the material field to equal the value in the 3rd column (ie. 2)
from the drop down field named cost. It is fine when I am sitting on the
record but if the navigate back and forth it reset the visible(?) value to be
whatever the last one that was put in. Any way to show the actual material
selected for each indivual record as navigate to look through the records
later in time???

Private Sub cost_AfterUpdate()
[material] = Me![cost].Column(2)
End Sub

Thanks,
Barb

 

[Douglas J. Steele]

You'd have to put similar logic in the form's Current event.