2 Column Combo Box

I am trying to create a 2 column combo box using the lookup wizard. But I want whatever field I choose in a column to be saved in the record. If I choose a field in column1, I want that to be stored in the record. However, if I choose a field in column2, I want that to be stored in the record. Can this be done.

Confused,
Chris

Combo's don't work that way. They are bound only to a single field and that field should be the unique identifier of the row in the combo's RowSource. It is possible to reference the other fields of the RowSource in code and store them but this is usually discouraged. You don't want to duplicate data since maintenance then becomes a problem.

If what you are asking is if you have a combo with CustomerID and CustomerName, can you choose which one to store - the answer is "you can't". You need to store the CustomerID because that is the field that will be used to "relate" the order table to the customer table for example. Whenever you need to see the CustomerName along with order information, you would use a query that joins the two tables.
--
Bridge Players know all the Tricks


"Chris" wrote:

I am trying to create a 2 column combo box using the lookup wizard. But I want whatever field I choose in a column to be saved in the record. If I choose a field in column1, I want that to be stored in the record. However, if I choose a field in column2, I want that to be stored in the record. Can this be done.

Confused,
Chris