selecting from combobox into a code

[Ssstacey]

HI,

I have an input form on which I have a combobox.
The user can choose from the list of products. However, I want to use this input in a code and I need the productid to work with in the code. How can I arrange it that when the user selects, they can see the name of the product and the id (not necessarily), but once the input is chosen only the id serves as input and thus in my code I only use the id ( number)???
Stacey

 

[Len Boorman]

The row source of the combo box is basically a query that you can create/change to suit yourself to show exactly what you want in the combo box.

The bound column is the column number whose value will be lopdged as the combo box value when selected.

Column widths may be set tosuit yourself again depending upon the data. Not that a column width of 0 effectively hides the field from the Users view. This could be the ID field. Combo box value becomes ID if this is bound column but user may not actually see it at all.

Len

 

[Ssstacey]

thank you.. that did it...
Stacey