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

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

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