How to make search more effective?

[longmatch]

I have a disgnosis table with 13600 records in my access database. I would like to allow user to search any words and return the records with the words users searched. How can I do this?

Thank you

Haijun

 

[ChrisCalvert]

Well, the simplest way to do this (I think) would be to use the findrecord method of the docmd object. I copied the following syntax from the help files:

DoCmd.FindRecord findwhat[, match][, matchcase][, search][, searchasformatted][, onlycurrentfield][, findfirst]


Set onlycurrentfield to acAll.

 

[longmatch]

Do you have any example for this kind search?

Big thanks

Haijun