String 'many' values into 1 field

[Sheila D]

I have a field in the many side of my relationship which stores information
on complications during a procedure. There are 10 possible values which I
have set as a Value List on the combo box but I also need to allow the user
to add items to the list if 'Other' complications arise thus I do not know
what the result may comprise.

I need to produce a report which looks at the combinations of complications.
Is there a way to loop through the results (the many side) for each procedure
(the one side) and combine them into a single text string which I can then
use to analyse results for my report?

Any help much appreciated. I did ask a similar question last week but may
not have explaine properly what I was trying to do so apologies if this looks
like a repost.

Sheila D

 

[BruceM]

This link may give you an idea about how to proceed with this:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16

You can set the Limit to List property of the combo box to No, which would
allow users to add items that are not on the list. If you want one of the
combo box selections to be Other, with the ability to add a list of Other
conditions, you will do best to use another table. This will probably
complicate concatenating the subform records, and it would mean you have to
use a single form to list the complications. If Other tends to be just an
item or two you may do best to allow the users to enter items that are not
on the list rather than going with a related OtherComplications table.

To help the users you could have Other as a combo box selection. If it is
selected, use the Before Update event for the combo box to clear the combo
box and instruct the user how to proceed:

MsgBox "Type other complications into the box, pressing the Enter key " & _
"after each one", , "Type Entries"
Me.ComboName.Undo
Cancel = True

If an Other complication shows up a lot you could add it to the Value List.
Better yet, use a table as the Row Source, with a simple user form to add
entries. There are ways to add an entry to a table by using the combo box
Not In List event, but I won't try to get into the details here. I think a
Value List can be similarly updated, but again you may be better off using a
table if the list has more than a few items.

 

[Sheila D]

Bruce

That has done exactly what I needed, thanks so much (and to Duane as well!)

Sheila