Hi,
I'm in the process of creating a database for my company in which
records are being kept on files that have been sent to different
clients.
My knowledge of code building is fairly basic, however, I am not
completely clueless.
What I need to achieve is a combo box, in a form
which allows multiple values to be selected and then each column in the
drop-down from the combo box to appear in the combo box list. So in my case, I
would like both the clients name and their association to appear once all
selections have been made rather than just the name which I am getting
now.
By using lookup wizard I have been able to select multiple values
for a field using a form and when the combo box drops down for selection, each
column that I have requested to be shown appears however only the first column
will appear when all selections have been made.
I have had success
concatenating fields which do not store multiple values. However, when I follow
the same method for the fields that do, I get an unnamed error code
(1613). (See .jpg's attached)
Any help would be appreciated.
Thanks in advance.