Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: Option Group Option Buttons

Geek News

Option Group Option Buttons
Stephen 12/9/2008 11:06:09 AM
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)?
--
STE
Re: Option Group Option Buttons
"Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 12/9/2008 11:53:23 AM
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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Stephen" <Stephen[ at ]discussions.microsoft.com> wrote in message
news:5F386398-578F-4A26-B504-36F05876C3E8[ at ]microsoft.com...
[Quoted Text]
>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)?
> --
> STE

Re: Option Group Option Buttons
Stephen 12/9/2008 12:17:01 PM
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.
--
STE


"Allen Browne" wrote:

[Quoted Text]
> 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.)
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Stephen" <Stephen[ at ]discussions.microsoft.com> wrote in message
> news:5F386398-578F-4A26-B504-36F05876C3E8[ at ]microsoft.com...
> >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)?
> > --
> > STE
>
>
Re: Option Group Option Buttons
"Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 12/9/2008 2:55:47 PM
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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Stephen" <Stephen[ at ]discussions.microsoft.com> wrote in message
news:3360C347-C26C-4E0A-94A4-DAF402020FD7[ at ]microsoft.com...
[Quoted Text]
> 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.
> --
> STE
>
>
> "Allen Browne" wrote:
>
>> 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" <Stephen[ at ]discussions.microsoft.com> wrote in message
>> news:5F386398-578F-4A26-B504-36F05876C3E8[ at ]microsoft.com...
>> >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)?

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net