Query behind form

[mIKE]

I created a form where the user enters more than one
customerID (separated by commas of course). Then they
click a command button to run a query.

I created an unbound text box, named text0 on the form. I
created a query that has the following expression in the
CustomerID field's criteria: In(val([Forms]![Form1]!
[Text0]))

When I run this query with more than one value... it only
returns the first value entered.

What I am doing wrong?

Thanks
Mike

 

[Shane Andrews]

mIKE,

Let me help. Are you saying that you want to extract multiple string
values from a text box? And that those values will ALWAYS be separated by
commas? Is this what you are saying?

Shane Andrews

 

[Guest]

Yes, so it will be similiar to using a parameter query
without using the default dialog box. The values will
always be separated by a comma.

-----Original Message-----
mIKE,

Let me help. Are you saying that you want to extract multiple string
values from a text box? And that those values will ALWAYS be separated by
commas? Is this what you are saying?

Shane Andrews

I created a form where the user enters more than one
customerID (separated by commas of course). Then they
click a command button to run a query.

I created an unbound text box, named text0 on the form. I
created a query that has the following expression in the
CustomerID field's criteria: In(val([Forms]![Form1]!
[Text0]))

When I run this query with more than one value... it only
returns the first value entered.

What I am doing wrong?

Thanks
Mike

.