Query behind form

  • Thread starter Thread starter mIKE
  • Start date Start date
M

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
 
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
 
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
Click to expand...


.
Click to expand...
 
Back
Top