ComboBox Fields

[Guest]

Thank in advance.
I have a main form bound via a query containing equipement to dispatch. On
the form I have an Combobox via a contacts query looking for a contact by
bringing up 4 fields (contact, company, telno & Pcode), user selects correct
contact - all is fine. However I wiould like to fill in 3 of the main form
fields with the info that 3 of the combobox colums contain.
Can anyone help
Many thanks Nigel

 

[Douglas J Steele]

You can refer to the additional columns as Me.MyComboBox.Column(1),
Me.MyComboBox.Column(2), and so on.

Replace MyComboBox with the name of your actual control. Note that column
numbering starts at 0, not 1. The two snippets above would return the
content of the 2nd column of the selected entry and the 3rd column
respectively.

 

[Guest]

Many many thanks, it worked a real treat

You can refer to the additional columns as Me.MyComboBox.Column(1),
Me.MyComboBox.Column(2), and so on.

Replace MyComboBox with the name of your actual control. Note that column
numbering starts at 0, not 1. The two snippets above would return the
content of the 2nd column of the selected entry and the 3rd column
respectively.