Robv56

I have experienced the same issue. Never took the time to figure it out though. I just changed it from POST to GET and updated the recordset accordingly and it worked as intended. If I get around to looking into it and figure it out, I will post my results.

Hello: I am trying to create searching capabilities for my database. The options are to directly enter an ID# or to select a Brand, a Category or a combo of either. I created a search page with 3 individual forms for each and it works fine, but I need to figure out how to allow the viewer to search any combination of BRAND (brand_id) and/or CATEGORY (category_id) from one form. Preferrably, I'd like to include the ID# (dcx_id) to the mix too, as explained in the first paragraph. What SQL code do I enter into the Advanced Recordset screen to accomplish this? Not sure if it matters, but I'm using Tom Mucks Horizonal-Vertical Looper to tile the results.