Select option button when have the name as a string

Hi All

During the running of my VBA code, I collect the name of an option button from an Access database. I then want to set the value of the option button on a form. My problem is that I have the name of the button as a string and just cannot see how to use that to set the value of the button on the form as, when used as a string, I get an error.

Hope the question makes sense to someone :-)

Many thanks
Deb

--
Message posted via http://www.officekb.com

Originally Posted by Debbie Probert via OfficeKB.com

Hi All

During the running of my VBA code, I collect the name of an option button from an Access database. I then want to set the value of the option button on a form. My problem is that I have the name of the button as a string and just cannot see how to use that to set the value of the button on the form as, when used as a string, I get an error.

Hope the question makes sense to someone :-)

Many thanks
Deb

--
Message posted via http://www.officekb.com

Hello Deb,

What you want to do is a very useful programming approach. VBA does it. However, the literature never reallys makes it quite clear how to it. So, here is how...
________________________________________________________________

Dim OptBtn As Object
Dim OptBtn_Name As String

'Set UserForm1 to the Name of the Form the Control is on
Set OptBtn = UserForm1.Controls(OptBtn_Name)

OptBtn.Value = True 'To set it
OptBtn.Value = False 'To Clear it
________________________________________________________________

Hope Tthis helps,
Leith Ross

Deb,

Use
Me.Controls(string_value)

with whatever property you want

--
HTH

Bob Phillips

"Debbie Probert via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:f4b38b89f72846d0aabc3123187a052b@OfficeKB.com...
> Hi All
>
> During the running of my VBA code, I collect the name of an option button
from an Access database. I then want to set the value of the option button
on a form. My problem is that I have the name of the button as a string and
just cannot see how to use that to set the value of the button on the form
as, when used as a string, I get an error.
>
> Hope the question makes sense to someone :-)
>
> Many thanks
> Deb
>
> --
> Message posted via http://www.officekb.com

Private Sub CommandButton2_Click()
sStr = "Button Name"
UserForm1.Optionbutton1.Caption = sStr
End Sub

I assume by name you mean the name you would see next to the button on the
form.

--
Regaards,
Tom Ogilvy



"Debbie Probert via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:f4b38b89f72846d0aabc3123187a052b@OfficeKB.com...
> Hi All
>
> During the running of my VBA code, I collect the name of an option button
from an Access database. I then want to set the value of the option button
on a form. My problem is that I have the name of the button as a string and
just cannot see how to use that to set the value of the button on the form
as, when used as a string, I get an error.
>
> Hope the question makes sense to someone :-)
>
> Many thanks
> Deb
>
> --
> Message posted via http://www.officekb.com