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
|
|||
|
|||
Combo box
Hi,
I have a combo box on a form that uses a table for the list. After you choose one from the combo box, I want it to let you add another choice from the combo box and put it in the same field.Is there any way to put a comma or simi-colon after the first one then put the second? Right now it will just overwrite the first one chosen. Thanks! Sara |
#2
|
|||
|
|||
Combo box
On Thu, 24 Jun 2004 12:40:09 -0700, "Sara"
wrote: Hi, I have a combo box on a form that uses a table for the list. After you choose one from the combo box, I want it to let you add another choice from the combo box and put it in the same field.Is there any way to put a comma or simi-colon after the first one then put the second? Right now it will just overwrite the first one chosen. Thanks! Sara Stop. What you're trying to do violates the very first principle of relational database design: fields should be 'atomic', i.e. they should have one and only one value. If you want to have a one to many relationship between the entity modeled by your main table, and this keyword, *you need another table*. Use a Subform based on the table, with the combo box on the subform, and add *one record* per keyword, rather than trying to jam multiple keywords into a field. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#3
|
|||
|
|||
Combo box
Hi,
I usually go to the Row Source on the Data tab (Properties) , open the query builder and group the list (from the Toolbar: View, Totals). Usually works for me. -- AusTexRich "Sara" wrote: Hi, I have a combo box on a form that uses a table for the list. After you choose one from the combo box, I want it to let you add another choice from the combo box and put it in the same field.Is there any way to put a comma or simi-colon after the first one then put the second? Right now it will just overwrite the first one chosen. Thanks! Sara |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filtering records using multiple combo boxes | Mark Senibaldi | Using Forms | 0 | June 17th, 2004 03:55 PM |
Cascading Combo Boxes | Tom | Using Forms | 1 | June 9th, 2004 02:04 AM |
Cascading Combo Boxes | Tom | Using Forms | 0 | June 8th, 2004 09:24 PM |
Combo Box Problem | Charles | Using Forms | 0 | May 28th, 2004 09:15 PM |
Multiple combo boxes | Lee | Worksheet Functions | 2 | May 6th, 2004 02:49 PM |