Selecting records using an input box

[fcecconi]

Hello

I would like to select multiple records in a table by using an input box.  I am able to select a single record, but not multiple.

I am taking my records from an excel spreadsheet and cutting and pasting into the input box.  I have tried both a | as well as a , as delimiters.

I am using a button to Select in Field.

What am I doing wrong?

[Anonymous · Accepted solution]

Delimiter | is correct, and don't forget the parenthesis:

(value1|value2|value3)

[maxgro]

and, if I'm not wrong, with space

("value 1"|"value 2"|"value 3")

[Anonymous]

You're certainly not wrong.  It is safe to use "" every time if there is a possibility of a space.

[fcecconi]

Thanks everyone.  I was able to get it to work.  I added a | in the excel data.  I then cut and pasted the data into the input box.  On the button I added '('& variable &')'  to the Select in Field value

thanks again!