P
Paul
I have a UNBOUND combo box with the items on the drop list based on a query
with two fields, the first column is the BOUND ID field. The combo box is
set up in a way that the first column is hidden from the end-user view. The
value selected on the combo box will be saved back to a table for that ID
field. The selection of the item from the drop list need to be coded since
it is coming from another form and it passes the value(not the ID field but
the value on column 2 of the drop list) to that combo box. I can paste the
value to the combo box, but when I save it back to the table, Access only
recongize it as the value in the column 2 rather than the value of the ID
field at the bound column 1. Thanks.
with two fields, the first column is the BOUND ID field. The combo box is
set up in a way that the first column is hidden from the end-user view. The
value selected on the combo box will be saved back to a table for that ID
field. The selection of the item from the drop list need to be coded since
it is coming from another form and it passes the value(not the ID field but
the value on column 2 of the drop list) to that combo box. I can paste the
value to the combo box, but when I save it back to the table, Access only
recongize it as the value in the column 2 rather than the value of the ID
field at the bound column 1. Thanks.