If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
2 Column Combo Box
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combo box lookup doesn't work when field is blank/null | Bob Richardson | General Discussion | 11 | July 27th, 2004 06:21 PM |
Data Dependencies between Combo Boxes | Tom | Using Forms | 7 | June 6th, 2004 05:25 PM |
Combo Box Problem | Charles | Using Forms | 0 | May 28th, 2004 09:15 PM |
Requery Combobox | MJ | Running & Setting Up Queries | 7 | May 25th, 2004 11:01 AM |
adding values from another worksheet by matching criteria | Frank Kabel | Worksheet Functions | 2 | March 16th, 2004 03:15 PM |