Prompt for mutilple values in a query

[DOTJake]

How can I prompt the user for mltiple values for a
parameter in a query.

I would like to have some thing like

WHERE [MYTABLE]![MYFIELD] in ['enter values:']

and allow the user to enter 1 to n values in the prompt.

Thanks
DOTJAKE

 

[Duane Hookom]

Not too easy to implement. You could possible set up the column/field to be
something like
InWhere:Instr("," & [Enter comma separated values] & ",", "," & [MyField] &
",")
in the criteria, enter

0

The user could enter values like "John,Joe,Bill,Jane" without the spaces.
--
Duane Hookom
MS Access MVP

How can I prompt the user for mltiple values for a
parameter in a query.

I would like to have some thing like

WHERE [MYTABLE]![MYFIELD] in ['enter values:']

and allow the user to enter 1 to n values in the prompt.

Thanks
DOTJAKE

 

[DOTJake]

That does it. Thanks !

Jake

-----Original Message-----
Not too easy to implement. You could possible set up the column/field to be
something like
InWhere:Instr("," & [Enter comma separated values] & ",", "," & [MyField] &
",")
in the criteria, enter

0

The user could enter values like "John,Joe,Bill,Jane" without the spaces.
--
Duane Hookom
MS Access MVP

How can I prompt the user for mltiple values for a
parameter in a query.

I would like to have some thing like

WHERE [MYTABLE]![MYFIELD] in ['enter values:']

and allow the user to enter 1 to n values in the prompt.

Thanks
DOTJAKE

.