Manipulating a pasted list

[Angi]

I'll TRY my best to be brief. I'm using Acc2002 with 2000 file
format.

My form (frmEvents) has 3 unbound controls: ComboBox (cboEvent with
source Event from Event table), TextBox (txtNameList) (lrg memo box),
and a CmdBtn(cmdAddEvent) that runs the append query (qryAddEvents).

My query (qryAddEvents) currently has 2 fields: Event & Attendees. In
my query, Event is = cboEvent, Attendees = txtNameList

I select the Event. Works fine.
I paste my list of people that attended the event into the TxtBox.
Click my button and the query runs, but if there is more than one
person in the txtNameList field, the query is blank.

I KNOW the problem, but I don't know exactly how to fix it. I need to
take the list and either pass a valid criteria string to a hidden
field and have the query read THAT field OR I can just set the
criteria for the query through code using the controls I have now.

What needs to happen is that a list that looks like

Joe
Bob
Jane
Lisa

in the text box, becomes
"Joe" or "Bob" or "Jane" or "Lisa"

If I go into the query and enter that exact line, the query does
exactly what I want it to do. SO, I thought about putting it all
together and then separating it using the capital letter (ONLY the
first letter of a new name would be capped) and then just formatting
that string, but I can't figure out how concatenate it in the first
place since I don't know how Access is viewing the line breaks.

Can someone please point in a starting direction (how access is
reading it) or give me a better idea of how to do this??

Thanks,
Angi

 

[KARL DEWEY]

Try this ---
Attendees Like "*" & [txtNameList] & "*"