This is kinda visiting a thread that I posted earlier today, but I feel I should elaborate on what I was trying to say. I have created two successful search forms based on queries that incorporate different tables. One form prompts a user with a combo box in which they select products. The product field in the query is based on this combo value and requeries once it is matched. I have a similar search form based on a vendor. The last search form that I would like to include would take many different text boxes and combo boxes and search these fields (with the option of leaving them blank). Is it possible to create query criteria that would allow for this? I know that if you set the criterias for each field in the query to equal their corresponding fields on the forms it will work correctly if all of the fields on the form are filled in. However, if left blank, this will not be accomplished. I tried the code that was in FAQ 702-1177. It worked great, but I am not sure how to use it if the information is pulled from different tables. For example, I have four tables of interest: tblCatalog, tblVendor, tblProduct, tblCatalogDetails (this table alleviates the many-to-many relationship between tblProduct and tblCatalog). I want to use a combo box with [VendorName] (from tblVendor), [Product] (from tblProduct), [Format],[CatDate], and [FiledUnder] (from tblCatalog). Could the code used in DougP's FAQ be manipulated to accomodate these changes? Is there a way to do this without even using code, but instead just using join queries? Thanks in advance!
Dan Eaton
deaton@caemachinery.com
Dan Eaton
deaton@caemachinery.com
