If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Modify existing Option Group structure?
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 |
#2
|
|||
|
|||
Modify existing Option Group structure?
On Fri, 26 Oct 2007 06:23:01 -0700, CW wrote:
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 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Modify existing Option Group structure?
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. -- Dave Hargis, Microsoft Access MVP "CW" wrote: 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 |
#4
|
|||
|
|||
Modify existing Option Group structure?
Oh dear, if it's that easy I'm feeling stoopid now.
Many thanks CW "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "CW" wrote: 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 |
#5
|
|||
|
|||
Modify existing Option Group structure?
Oh dear, if it's that easy I'm feeling stoopid now.
Many thanks CW "fredg" wrote: On Fri, 26 Oct 2007 06:23:01 -0700, CW wrote: 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 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|