VBA to display an average value as a radio button

[boo]

I originally posted this query in the forms section, but in retrospect I think it may be solvable with a bit of VBA code. Any suggestions are appreciated -



Hi

I have a form, frm_Feedback, which displays the feedback received for each job done by the related interpreter. The frm_Feedback allows a radio button to be selected, either - Very Dissatisfied, Dissatisfied, Neutral, Satisfied, or Very Satisfied. Each one of these then assigns a value for each job from 1 (Very Dissatisfied) through to 5 (Very Satisfied). Is it possible to display the average for all jobs in the same way, ie showing the 5 radio buttons with the average one selected?

Thanks.

So essentially what I want to do is get code that means if the average feedback score is : 0 - 1.5 then optVDisatisfied will be checked, 1.51 - 2.5 optDissatisfied will be checked, 2.51 - 3.5 optNeutral will be checked, 3.51 - 4.1 optSatisfied will be checked or > 4.51 optVSatisfied will be checked.

[boo]

I have a text box , txtAvgFB, which contains the average for the feedback scores, so this is what I wish to refer to.

[boo]

OK I figured a way of doing it without using VBA. I rounded the value in txtAvgFB using =round(Avg([Feedback])), then changed the control source for my option group containing the radio buttons to =[txtAvgFB].