Combo box

[teiben]

I have two tables: WorkOrder & MachineType; The machine type table has a ID and all the machine types 0-12;

THe form Request, has a combo box, that uses the row source type "MachineType" to store what the user selected (so the number value is getting stored);

Problem is there is a command button that extracts information from the form and puts it in an email message, but the combo box gets reported as a number and not the corresponding machine type. I don't remember how to change either the email or the combo sourse.

 

[scottfarcus]

The default value of the combo box is in the bound column. Use the Column(index) property to access other data within the combo box. For instance, if the bound column is column 1 (ID) and the column displayed is column 2 (MachineName), you would return the machine name using...

ComboBox.Column(1) 'NOTE: Column collection is zero based

instead of ComboBox (which would return the ID).

 

[WayneRyan]

teiben,

You have a multi-column combo-box.

Your s/w is sending column 0, which is probable the number
of the machine. You want to send the column value that is
displayed.

Wayne