Multiple Keyword Search

[ekta]

Hello Everyone

I have a question. I have a form which has about 15 fields including 2 subforms. Now I want to create another form where the user can do multiple keyword search based on the form I mentioned above. The user can type anything in the text field and get the result. Please advise me on this.

Thx in advance
Ekta

 

[Fizzio]

How you could achieve this is to create the SQL string dynamically by code and use this for the recordsource of the form
Initially you would need to split your string up into chunks of words entered then add them to an OR or an AND clause of a SQL query to filter the results. Hope this gets you started.

Here is an example NB Split does not work in A97

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32553&highlight=split+string

 

[ekta]

I kinda understand it but dont know exactly how to do it. I am not very proficient in VB