I want to build a query that passes the value in the form to the query and check is the value is eq to yes. I have a field on a form called type and it can contain a variety of products, computer, server, camera, etc. I also have another table questions that has all those products with a yes/no to indicate if that question is appropriate to the type of product. I need to somehow do something like: pass the value on the form.type value [computer, server, camera] to the questions table where the criteria is equal to yes.
This action would need to occur on a page load event.