Extract data from text box

[Steven K]

Hello,

I have two controls. One is a multiselect list box and another is a text
box. A user can select multiple items from the multiselect list box and
move the selection to a text box. What I need to be able to do at night is
run a script that will extract each item in the text box and insert it into
a table.

Any help with this would be appreciated.

Thanks in advance, Steven

 

[John Vinson]

Hello,

I have two controls. One is a multiselect list box and another is a text
box. A user can select multiple items from the multiselect list box and
move the selection to a text box. What I need to be able to do at night is
run a script that will extract each item in the text box and insert it into
a table.

Umm... this makes me really queasy! You want to store MULTIPLE values
in a single field? Why?

What you can do (if you really want to violate first normal form in
this way) is to simply have the textbox bound to the Text (or Memo, if
the length of the text will exceed 255 bytes) field in the table, and
fill the textbox using your code. It will be saved to the table when
you move off the record or explicitly save the record (using
DoCmd.RunCommand acCmdSaveRecord for instance).