I used the Option Group Wizard to create a customer satisfaction record page
with 4 ratings from Excellent to Poor, scoring 4 to 1 respectively.
There's an underlying table to store the scores, and a query to report upon
them.
It all looked great, then the boss asked me to add another option button for
N/A, which would score 0.
How do I modify the structure on the form to add a further checkbox option?
Thanks
CW
fredg - 26 Oct 2007 16:03 GMT
> I used the Option Group Wizard to create a customer satisfaction record page
> with 4 ratings from Excellent to Poor, scoring 4 to 1 respectively.
[quoted text clipped - 5 lines]
> Thanks
> CW
Open the form in design view.
Click on the ToolBox Tool button.
Select the radio button and drag it inside the Option Group frame.
The button will have an Option Value of 5.
Select this new button.
Display it's property sheet.
Click on the Data tab.
Set the Option Value to 0.
Save the changes.

Signature
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
CW - 26 Oct 2007 17:28 GMT
Oh dear, if it's that easy I'm feeling stoopid now.
Many thanks
CW
> > I used the Option Group Wizard to create a customer satisfaction record page
> > with 4 ratings from Excellent to Poor, scoring 4 to 1 respectively.
[quoted text clipped - 15 lines]
> Set the Option Value to 0.
> Save the changes.
Klatuu - 26 Oct 2007 16:06 GMT
Open the form in design view.
Select the appropriate control type for the options in your existing group.
buttons, check boxes, or whatever the other options are. Put it in the list.
In the properties dialog, make the Caption N/A and the Option Value 0.

Signature
Dave Hargis, Microsoft Access MVP
> I used the Option Group Wizard to create a customer satisfaction record page
> with 4 ratings from Excellent to Poor, scoring 4 to 1 respectively.
[quoted text clipped - 5 lines]
> Thanks
> CW
CW - 26 Oct 2007 17:28 GMT
Oh dear, if it's that easy I'm feeling stoopid now.
Many thanks
CW
> Open the form in design view.
> Select the appropriate control type for the options in your existing group.
[quoted text clipped - 10 lines]
> > Thanks
> > CW