Multi Select Lists and copying info to comments field

[Des King]

Hello

I have a DB with a table (tblservers) listing all the servers in our
organisation and another table which contains Change Request information
(tblChangeReq)

On the Change Request table, I have a field "ServersAffected" which is a
memo field as there could be over 100 servers affected by a change. I want a
user to select the appropriate servers in the list to add those server names
to the "ServersAffected" field. I just want them as text values.
I tried using the list box wizard which will update one server name to the
"ServersAffected" field and then I have tried changing the multi select
options of the list box to simple or enhanced, but this doesn;t copy anything
over.

Is this simple to resolve or a major piece of work. I have very little VB
skills so if I can achieved this by using macros or event builder, i'd be
happier.

Cheers

 

[Allen Browne]

No. You cannot manage this without writing code for at least the Current
event of the form, the Undo event of the form, and the BeforeUpdate event of
the form. And then you still have a 2nd rate solution.

The better idea would be to use a related table. The interface will be a
subform where you can enter as many servers as needed for each record in the
main form, one per row. No code needed, and the result is excellent design:
easy to query and manage.