Alter Parameter by button

[matthewnsarah07]

I currenly have a database handling responses to staff tests.

To keep the number of forms down I want to use only one form containing a subform running from a query 'qryQuestionForm' but I have seven categories of questions.

The query look to the previous form for [StaffID] and [CheckPeriod] but I have [QuestionCategoryID], this is the field I want to change so when the button for say category 1 questions is clicked the query only show cat 1 questions and so on

What will be the best way to do this without writing 7 queries?

 

[DCrake]

This can be quite easily however are there questions that can be in more than one category?

For each of your questions you need to have a field that is the id to the category then in your query you filter the table based on the category key.

David

 

[matthewnsarah07]

Thanks David

Fortunately there are no multiple category questions. I have rectified this issue now by using an unbound text box [category] which is populted when you click the command button - the query can then refer to this field

Thanks