Option Group Option Buttons

[Stephen]

I have created on a Form in my Database an Option Group with 3 Option
Buttons, so that for each Record I can select 1 of these Options to have its
value stored in a particular Field of the Databbase Table. However, I do not
know, and have been unable to find a solution through MS Access Help, how to
program the Properties of the Option Group or the 3 Option Buttons so that it
will show a Default Option selected (Dot in Option Circle) when I go to a New
Record, select a different Option, and have the Value associated with the
selected Option stored in the linked Field of the Database, when the Record
is saved (via a Commmand Button) or a New Record is started (via a different
Command Button)?

 

[Allen Browne]

Open the form in design view, and set the Default Value property of the
Option Group.

Each button in the group has an Option Value. So if you want the one with
option value 1 as the default, set the group's Default Value to 1

(I assume you already have the Control Source property of the Option Group
set to the name of the field where you want the value saved.)

 

[Stephen]

Have done/checked all points below, but it still does not show Dot in third
Option circle. I didn't mention before that in the linked Field of the
Database Table, it is showing the value -1 for all entered Records and the
value 3 (the Default Option choice) in the blank new Record row at the end of
the Table.

 

[Allen Browne]

You have 3 buttons in your option group.
Your option group is bound to a Number field in your table.
You have set the Default Value property of the group to 3.

One button has the Option Value -1.
Another has the Option Value 3.
We don't know what the Option Value of the other button is.

When you go to a new record, the option button that has the value 3 is
automatically selected. You can change it to another value by clicking
another button.

After you save that record, when you move to another new record, the option
value 3 will be automaticallly selected again. That's what the default value
does.

If that's not what you are trying to do, I have not understood you.