It is not recommended to store multiple pieces of data in one field of one
record. If multiple entries will be common for that field, make another
table for that field and link it to the current table on the ID field of the
record in the current table. You can now make one record for each of the
entries you are wanting. A listbox, instead of a combo box, may be a good
way to display this. A subform would be another option.
--
Wayne Morgan
MS Access MVP
"Rupert Street" <ja**********@yahoo.com.au> wrote in message
news:3a**************************@posting.google.c om...
I have set up a combo box that contains descriptions of work carried
out. I would like if possible to click on one entry then click on
another to combine both entries to make a single entry separated by a
comma eg (entry 1) data input (entry 2) plan preparation = data
input, plan preparation. Can someone let me know if this possible and
how to go about it - thanks.