searching with multiple parameters

[Dammit]

I'm making a search function for a database using the "Find" method and an example on MSDN I found about it (the example (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthfindjs.asp))

But now I'm wondering if I can use multiple search parameters, like search for a number greater than 1000 but smaller than 2000 or would I need to use "Seek" instead ?

I've already tried a few things and looked around on MSDN but so far without any luck :(

[Roy Sinclair]

Looking at your example I simply followed the links and found this (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthfindmethodado.asp) page where it clearly states you can only compare on one column which also implies they don't allow for compound conditions.

Check out the filter (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprofilter.asp) property which does support compound conditions.

[Dammit]

I read the part about it not supporting multiple column search, but I didn't know that also meant it could only search with one condition. :o

Anway, thanx for telling me about the filter property to realize it :)