Feild data

[Keith]

I have a combo box that the user can use to select an
Option, the selection K_ID is saved in the option feild.
The combo box gets its data from a tabel. The table looks
like this.

K_ID Option Name Fee
1 Table 10.00
2 Bench 15.00

So when the user picks the "Table" option the Option K_ID
is stored in the option feild and "Table" is displayed in
the combo box. I would like to have a 2nd feild that also
gets its data from the option but this feild would
display 10.00. This way when the user picks the Option
Table the 2nd feild shows the corresponding fee.

How can I do this.???

 

[Allen Browne]

If you have all 3 columns in the combo, you can use its AfterUpdate event
procedure to copy the fee from the third column to another text box on your
form:

Private Sub K_ID_AfterUpdate()
Me.txtFee = Me.K_ID.Column(2)
End Sub