Hi,
like this:
--> Me.txtTheMemo = Me.txtTheMemo & " " & strNewPhrase
Me.txtTheMemo is the description already in the memo field.
strNewPhrase is the text phrase from the list.
You add a new phrase from the list by using &, then add a space " ", then
use & to add the new phrase.
Do this each time a new phrase is added.
Jeanette Cunningham -- Melbourne Victoria Australia
Jeanette,
Thank you so much for your response.
I think that my description was not adequate. From the form, the user
will pick words or phrases from a previously prepared list which will
then populate a bound Memo Field. As each word or phrase is chosen,
it appends itself to the previous phrase in the Memo Field, thereby
building a description which will be saved as part of the record. The
list will contain, for example, words and phrases such as:
TV Ring Power Tool Guitar Computer
LCD Plasma Gold Diamond Table Saw Miter Saw Drill
Electric Acoustic Laptop Desktop
Sony Toshiba Dell Fender Gibson HP Washburn Stratocaster
Telecaster
19inch 27inch 32inch 36inch
Multiple items are chosen from the list using mouse clicks to build a
description in the Memo Field such as: "Sony LCD TV 32inch" or
"Fender Stratocaster Electric Guitar." When the user is satisfied
with the description in the Memo Field, they simply move on the the
next field in the form.
The list is not bound and simply contains items which can be plucked
for insertion in the Memo Filed. The list can be edited to add or
remove items as needed with no effect on already existing records.
Please forgive my clumsy effort to describe the problem. Once again,
any help is appreciated.
