Form Checkboxes to Define Query

[slyvsspy]

How would someone go about setting up a form that a user can use to define all the paramaters they want for their query. There are many parameters and I don't want the user to ever touch the query or manually fill a parameter in, so I want the user to be able to fill in the parameters in off of a form .

any ideas at all

thanks, josh

 

[cogent1]

How about setting up combo boxes based on value lists and preventing additions. Then the parameters refer to the form and combo box name. That's the most straightforward way.