Simple question 1

[PBXJay]

For some reason Access help files and my access book don't go into detail.

Looking to create simple radio/choice button for input

1. computer
2. phone
3. software

I have set up an indexed table with these choices called troubletype

How do I link them?

 

[fneily]

In your table, you'll create a field with a datatype of number.
On your form, you'll create an Option Group by clicking on its' icon on the ToolBox toolbar. You'll get the Option Group wizard. Type in your choices. Click next. Set your default. Click next. DO NOT CHANGE ANYTHING HERE. Click next. Select "Store the value in this field" and select the number field in your table. Click next and select your style. Keep it Radio Buttons. Click next. Name it and Finish.
The way it works is this: it'll store the NUMBER of the option, not the description. So you'll create a little table with two fields, DescripID and Description. DescripID will be the exact numbers you have in the option group. Description is your labels.
So when you want to make a report, you'll have to link them in a query first to get the description.

 

[PBXJay]

Must be doing something wrong I clicked on optioni group but did not get the wizard. Checking to see if it is installed option

 

[fneily]

Make sure the Wizard button(the button with the wand and stars) on the toolbox toolbar is pushed in.

 

[PBXJay]

Ah... somehow the control wizard button on toolbox was not activated first

 

[PBXJay]

LOL I was just doing that fneily when you posted