Jump to content


This topic is now archived and is closed to further replies.


Search options

Recommended Posts


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.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.