Query with parameters from a form text fiels

[Rich47]

I have Make Table query where I want to add new records based on numbers in a Form text field.

In the criteria section of the query I have [forms]![MyForm]![Text1]

I want to be able to enter several numbers in the Form text field to add multiple records to the table. I have tried entering in the text field "2" or "4" or "6" running the query but no records are returned. If I just enter one number "2" it works fine so I'm guessing it can't interpret the "or" clause.

I have also tried in the criteria box of the query- In([Forms]![MyForm]![Text1]) and then listed a series of number in the test box e.g. 2,4,6 still works with only one number but not several.

I think I have triedjust about every possible combinations of quotes, commas, and & symbols, but no luck.
Any suggestions?

 

[dhookom]

As you have found, this won't work. You might be able to use syntax like:

SELECT *
FROM [YourTableNameHere]
WHERE Instr("," & Forms!MyForm!Text1 & ",","," & [YourFieldNameHere] & "'")>0;

This assumes your text box has comma delimited values with no spaces.


Duane
Hook'D on Access
MS Access MVP