Multiline textbox query search

[gustavoavila]

Hi folks,
First of all, I'm very happy to enter in this community. I'm pretty sure that I will find a lot of knowledge and I will try to help everytime I can.

This is my case:

For weird reasons, in my new job, the business rule is use Excel and Access only solutions. I have some expertise working with some DBMS like MySQL/MSSQL and developing webforms in PHP. The point here is, I'm "forced" to work with forms in access. The problem here is: I don't have any expertise working with Access.

So, I'm trying to create a simple form to search multiple values in one textbox. I want to paste the values in the textbox (every row contains a single record), and display the query result. I don't have any problem to show the query results, but I'm stuck to make that Access read every single row to find every record.

Ex:

[textbox data]
Record1
Record2
Record3
Record4
....


Query:

SELECT Classifications.WisperPlantID, Classifications.ClassificationCountry, Classifications.PartNo, Classifications.PartNoDescription, Classifications.ClassificationCode, Classifications.COEProject, Classifications.BU, Classifications.CreatedBy
FROM Classifications
WHERE (((Classifications.PartNo) like "*" & [Forms]![Search]![Text0] & "*"));

If I run with 2 or more record in the textbox, the query returns no results, but If there is only 1 record in the textbox the query runs like a charm.

Do you have any idea how to do multisearch with 1 textbox?


Thanks in advance for your help.



Cheers!!!!

[June7]

That WHERE clause won't work, this one might:

WHERE InStr([Forms]![Search]![Text0], [PartNo])>0;

Here is example of code to construct a multi-value criteria http://allenbrowne.com/ser-50.html

The code constructs a comma-separated string and applies it to the WHERE CONDITION argument of OpenReport action using the IN operator.