Combo box confusion

[Lou_Reed]

In the file that I have attached, I have a question. In the form HelpDeskTickets the control HelpDeskEmployee



is used somewhat confusingly. There is a combo cboRecievedBy that uses a help desk employeeID, however, the
selection of the combo box only consists of help desk employee names no IDs are any where to be found.

So how does this work?

Also,

StrHelpDesk = Me.cboReceivedBy.Column(1).

is vague (at least to me) I know what the command

StrHelpDesk = Me.cboReceivedBy

means. It is just that ending part .Column(1) is confusing.

Could someone explain this to me?

Thanks in advance.

Respectfully,

Lou Reed

[Bob Fitz]

It is just that ending part .Column(1) is confusing.

Could someone explain this to me?

When a selection is made in the combo box the value saved is actually a value that is not displayed in the combo box which is the value in the first column. You can examine what columns are in the list by viewing the Rowsource as a query. The columns are referenced by counting them from left to right but they start with the value 0, so column(1) actually refers to the second column.