Prompt for mutilple values in a query

  • Thread starter Thread starter DOTJake
  • Start date Start date
D

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
 
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
Click to expand...
The user could enter values like "John,Joe,Bill,Jane" without the spaces.
--
Duane Hookom
MS Access MVP


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


.
Click to expand...
 
Back
Top