Updated field based on list box

[Caroline]

I have a field on a form called 'related complaint upper'
and in it lists a bunch of medical conditions. I have
set the the multi-select property to Simple so that I can
select more than one item on the list. Then I have
created a button on the form that I would like to be able
to push which would run some sort of Event Procedure and
would populate another field on the form called 'Related
Complaints'. These would be kept on a table. My trouble
is figuring out the correct Event Procedure to do this
update.
I am taking this project over from someone else. They
originally had an Event Procedure in the first field
called 'related complaint upper' that would work on a
double click. The problem was that once the user double-
clicked an item from the list it went right away to
the 'Related Complaints' field and they didn't have a way
to unselect it. I think that with a button that will
solve the problem they were having. They can just select
all the items, when they are sure of what they have, they
can click the update button. I tried to move the Event
Procedure from where they had it originally ('related
complaint upper') and put it with the button but that did
not work.

Any help would be greatly appreciated.

 

[Allen Browne]

Hi Caroline

You really need to change the way this works, so that there is a related
table where the related medical conditions can be stored, one per row. The
interface will then be a subform. In the subform you can use a combo box
where the user can select the medical conditions, and they can add as many
rows as they need.

There is absolutely no way I would consider using a multi-select list box
for storing this kind of data. Although it is possible, the work involved is
completely unjustified, and the results are very poor when you try to query
them.