Select option button when have the name as a string

[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

 

[Bob Phillips]

Deb,

Use
Me.Controls(string_value)

with whatever property you want

--
HTH

Bob Phillips

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.

 

[Tom Ogilvy]

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

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.