Building comments from a list

[Allen Bukosky]

My customer wants to be able to build the text in a comments field from a list of comment snippets stored in a separate table. I have a form showing several fields including the Comments field along with a list box showing the available snippets from the Snippets table, but I can't find a way to concatenate what is already in the Comments field with a selected snippet. However it works, it needs the ability to add more than one snippet (ie - each snippet is added as it is clicked(or double clicked).



I'd prefer to stay away from VB if possible (someday I'll have to learn it).

[Stingaway]

To concatenate the fields into one field (hidden or visible) you can create a text field and then make it's value equal to something like:

[Field1] & ", " & [Field 2] & ", " & [Field 3]

This would take the value of Fields 1 - 3 and concatenate them with commas in between.

Optionally, if you sometimes have data in Field 1 and 3 but not field 2, you could throw in an IIF statement to ignore the field if it is null, only concatenating the ones you want.

Hope it helps.

[Allen Bukosky]

Ahh, but how do I get this compound string to be stored in the comments field. I've tried -on click {in the Snippets list box properties} = [comment]=[comment]& [snippet] and slight variations- but usually get an error message or it simply doesn't work