Multiple Choice Parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

acss - 22 Apr 2008 17:52 GMT

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])

Reply to this Message

Jerry Whittle - 23 Apr 2008 15:46 GMT

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

Signature

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
[quoted text clipped - 3 lines]
>
> MYPARAMETER: InStr([ ENTER CTRY SEPARATED BY COMMA],[VendorCtry])

Reply to this Message

acss - 23 Apr 2008 16:15 GMT

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?
>
[quoted text clipped - 5 lines]
> >
> > MYPARAMETER: InStr([ ENTER CTRY SEPARATED BY COMMA],[VendorCtry])

Reply to this Message