How to autofill a description when a related record is selected...

[rogerarce]

I have a table called "plants" which has the following field names: Code,description,price. I want to know if it is possible that when (in a form) someone chooses the code from a combo and the remaining fields are updated with the specific info.
Thanks
Roger
rogerarce@softhome.net

 

[Aivars]

Hi!

If combobox contains information which you need:

me.txtDescription=me.cboComboBox.column(1)

First column of combobox is numbered 0, second one 1, third one 2 etc.

Aivars