Seach fields based on checkbox selection

[nibo]

I'm using WA SuperSuite with an Access database and ASP VBScript.

I've searched this forum but can't find a solution. I've also tried to download the PDF - Database Search Recipes after logging in to my account, however the link isn't working.

I would like to have a form which has one text search field and then several checkboxes which relate to various fileds in the table. On submission the results page would only search for the keyword(s) in the fields which have been "ticked" in the search form. i.e.

Seach for: ___________ [ ] Manufacturer [ ] Model [ ] Description SUBMIT

I'm not aware of a way to achieve this using WA Database Search, so if someone could help me out I would very much appreciate it.

Cheers.

[Ray Borduin]

You would have to manually update the code after application.

Set it up to filter two fields... say Manufacturer and Model with DataAssist Search.

Then create your radio buttons and update the associated code to get the list of columns from the form. There is no way to do it without hand coding this portion since you need to select a column in the interface and can't get that from a form field.