List Box and a Memo

  • Thread starter Thread starter Bruce Rodtnick
  • Start date Start date
B

Bruce Rodtnick

I have a form that has a memo field that will list subjects, i.e.

History
Social Studies
Political Science

I would like when you enter that field that a list pops up of examples
of subjects. You then double-click on a subject and it appears in the
memo field. A combo box would work except that I need the ability to
put several subjects in the field.

I don't have any problem with the pop-up. I just can't get the info to
transfer from the pop-up to the memo box.

Bruce
 
It is possible to write code that loops through the ItemsSelected in an
unbound multi-select list box to create a string that concatenates the
values from the appropriate Column, with an appropriate separator, and then
cut the trailing separator and assign the resultant to a text box bound to a
memo field.

Probably a bad idea through: you would use a subform control to add multiple
records to a related table. No code needed, and the data is stored correctly
instead of the fundamentally flawed approach of storing multiple items in
one field instead of keeping your data atomic.
 
Back
Top