How to solve this problem?

[Tsung90]

Hi, in my frmExerciseClass I need to be able to allow members or non-members to provide feedback for an exercise class they have taken part in or provide no feedback at all. I need to be able to store it either at a class level (X% positive feedback) or at a person level (John Smith chooses to like this class).

In my tblExerciseClass:

Column 1: Exercise_Class_No

Column 2: Exercise_Class_ID

Column 3: Member_ID

Column 4: Full_Name

Column 5: Date_Exercise_Class

Column 6: Time_Exercise_Class

Column 7: Feedback

Is there any way I can fulfil the task mentioned above?

Thanks.

 

[Isskint]

one way to achieve this would be to lock the feedback column and place an option group on the form with say 5 radio buttons. Buttons could be numbered, worded (poor, fair, good etc) or blank. The user would provide feedback by clicking the relevant radio button. In the on click event for the frame have it put this value in your feedback column. you can then query this value to identify class level feedback. personal level feedback would be as recorded.

 

[Tsung90]

I understand what you're saying but how would I place an option group on the form with 5 radio buttons? For the personal level feedback, I would haven't to add anything or do anything if I added an option group on the form with 5 radio buttons, right?

Thanks.

 

[Tsung90]

I have done it now, thank you very much. Much appreciated.

 

[Isskint]

Glad i could help