Select multiple records with "In" by user input?

[fluffyozzy]

Erm, I feel really silly asking this because it's probably simple to do, but my brain is refusing to work.. I searched a little bit for this, but can't find an answer (probably too simple).

I have a table and would like to prompt the user to enter multiple IDs of these records, separated by a comma between each value. Query works very well if I enter in the criteria something like:

In (1,2,3,4)

but it doesn't work at all if I enter:

In([please enter ID numbers])

How can I get the contents of what they put on the pop-up box to between the parentheses in the IN parameter?

Thank you in advance and please forgive me for being so brain-dead this morning

 

[fluffyozzy]

mmm, post viewed 20 times and no suggestions???

Hi everyone,

Although I haven't been working on this particular problem, I STILL can't find an answer to this. Is it even possible????

Please, your response (any response) would be much appreciated.

 

[Rich]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;100131

 

[fluffyozzy]

Thank YOU!!!

I don't know how I missed that! I'll probably need to work more on my searching skills

I'll leave now, with a red-face, thank you for replying master Rich