Multiple Choice Parameter

[acss]

I have used the Instr for providing the end user a choice of multiple
parameters and it works but i have tried to use this option on another field
called vendorAccts so results will be filtered per the multiple accounts &
Multiple VendorCtry entered but it does not work. Is the Instr limited to be
used on field within a query?


MYPARAMETER: InStr([ ENTER CTRY SEPARATED BY COMMA],[VendorCtry])

 

[Jerry Whittle]

Could the space between the [ and Enter be the problem?

 

[acss]

I tried using Instr in one field and it worked fine resulting in multiple
records but if i inserted it into another field then query runs through it.
Is it possble to use the Instr within two fields within one query.The only
thing i can think of is using the "OR" in another fiedld but that would cause
multiple prompts from that field.

Could the space between the [ and Enter be the problem?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have used the Instr for providing the end user a choice of multiple
parameters and it works but i have tried to use this option on another field
called vendorAccts so results will be filtered per the multiple accounts &
Multiple VendorCtry entered but it does not work. Is the Instr limited to be
used on field within a query?


MYPARAMETER: InStr([ ENTER CTRY SEPARATED BY COMMA],[VendorCtry])