Form Driven Query Problem

[DBnub11]

Hi All

I am having a problem with this form driven query I have set up. My intension is ot have a search form that sits over a table. Users can enter in what infomration it knows into combo boxes. The information will be used to launch a query. Seems simple and I set it up. the problem is that if one of hte boxes is left blank the query takes it as [something] = "" and I get zero records. I want it to behave where if it is blank to not use it as a criteria value and ignore it. Any advice, I have 7 differnet fields that the user could search on. I would want it so they could use any combination of info to find what they want.

Another note is there a way I could do multiple types of criteria on the same form with the same query. For example a vendor search have an option to llook for exact match or a containing some string serach.


any help is much appreciated.

Thanks in advance.

 

[John Big Booty]

The sample posted here, may be what you are looking for, at the very least it will give you some pointers.

 

[DBnub11]

OK I see the code and that works nicely, MY only question is can I stack the code

so duplcate it like 3 or 4 times and each be limiting the results. This would be sitting on an acounting DB where a vendor may appear multiple time. The link shows a great way to handel the vendor search but I would still like to limit the resutls a bit more with another text box looking for other details.

Thanks




The sample in the link is an amazing piece of work!!

Thanks big booty!!!!!!!!!!!!!!

 

[Brianwarnock]

Mayb this Link is more what you are after.

Brian

 

[DBnub11]

On the money Brian

this is fantastic between the two I have what I need.

Thanks a bunch case