Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2007

Tip: Looking for answers? Try searching our database.

Modify existing Option Group structure?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CW - 26 Oct 2007 14:23 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.
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.