Combo box control

[Guest]

I have a form with combo box that is used to select an "incident code" from a
table which also contains the "code" and "description". The sode is
displayed in the feild after selection. I have another feild on the form I
would like to copy the code "description" to after the "code" is selected,
then be able to edit it if necessary. What is the best way to "update" the
description feild on my form using the default "code" description from table.

Thanks
Jeff G

 

[Steve Schapel]

Jeff,

Make the combobox so that it includes both columns from the Codes table,
e.g. set the Column Count property of the combobox to 2.

Then, in the After Update event procedure of the combobox, put the
equivalent of...
Me.Description = Me.YourCombo.Column(1)

 

[Jeffery]

Thanks Steve- I will give it a try.

-----Original Message-----
Jeff,

Make the combobox so that it includes both columns from the Codes table,
e.g. set the Column Count property of the combobox to 2.

Then, in the After Update event procedure of the combobox, put the
equivalent of...
Me.Description = Me.YourCombo.Column(1)

--
Steve Schapel, Microsoft Access MVP


.