Subform options visibilty

[aman]

Hi Guys

I have a question regarding sub forms. I have a subform which displays a list of assessment questions and next to each question there is grading (option buttons). At the moment I have put 3 options buttons so the users can choose grading in (Yes,No,N/A). This works fine so far.

But now I got a change request and for some of the questions the grading will be in (Yes,No,N/A) and for some of the questions grading will be (A,B,Fail) , for some it will be (A,Fail) and for some it will be (Yes,No)

How can I accommodate this variation of grading within a subform?

All the questions are stored within a table so I was thinking to display 'labels for grading' within a table for each question so each question within a table will be linked to Grading . And then within a subform , display grading label values for each question separately but how can I make the option button visible or invisible for some of the questions as some questions don't have 3rd option button.

Any help will be much appreciated.

Thanks

 

[MajP]

Is this a continuous subform (multiple records visible) or single record view? If it is only one question visible at a time (single record view) then you can use the subforms oncurrent event which happens every time you change records to set the labels and visible property of the options. If this is continous form view, I am not sure if there is a solution using options since you change "one" control all controls will change. There may be something you can do with conditional formatting, but not with options.

 

[aman]

Mine is a continuous form as the end users want to see all the assessment questions at the same time . How this can be done using continuous form?

 

[Minty]

You can enable and disable controls using conditional formatting, that combined with clever use of colours / layout might get you where you need.

 

[MajP]

You might be able to fake this using conditional formatting, but it would be kind of "kludgy". You can use conditional formatting on textboxes and comboboxes not on optons. So you could use textboxes, but make them look like fake options or buttons. Instead of typing into them you will use the click event to set the value. With some code you can make them look like they are pressed. Then you would use the conditional formatting to hide certain controls. You do this by making the forecolor, backcolor of the control the same as the form. You could make this work but I think it would be a lot of effort for not such a great result. If you wanted something slick, where you had option buttons with different labels and number of options I think I would do an unbound form. Then I would have say x questions per page and ten sets of controls. Then you would be able to load x questions at a time and fully configure. That would be some work.

The easiest would be to have two subforms. The first is a list of the questions and answers (if answered), the second subform is a single form view. You use the first list only to navigate and it is synched to the single form view. Whatever question is selected in the list shows in the single form view. You could then configure the single form view for entry for the question you are on. I think this would look better and definitively give you better options to format the controls the way you want.