Query to look up value based on form field

[c.stewart28]

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.

[ranman256]

select * from table where [type] = forms!frmFind!cboType

There is a button called the BUILDER. It will let you click thru objects and select the one you need. It prevents misspellings.
put the cursor in the criteria box and click builder.