Greetings
Here is an odd event, I've created a combo box with values from
a field in another table. I Used ADO to save the value to another table.
Instead of saving the (Name) value, it saved the number value.

Ex. I picked the forth name listed, it would save the number 4
instead or the persons name shown. Here is the code:
        Rst.Fields("TOTALEngr") = cboTOTALEng.Value
What is going on here and how can I fix this?
Thanks


John Paul Hailey

__________________
John Paul

Folks, I just found the answer, The combo box was pulling a query from (2) fields, the ID and the Name. The first field (id)that
placed the info. I checked the ROW Source and the Column widths and found it. Once corrected the info was placed correctly!
thanks

John Paul

If you use the Combo Box wizard, it will display the value you select, and hide the primary key, and then bind to the PK field. If you either change the Bound Column to 2 (or which ever you want) or indicate which column you want in your code:

sVariable = Me.ComboBox.Columns(1)

then you won't have this problem. A good bit of detective work there.

mmcdonal