Radio Button to show fields

[Guest]

I would like to have a radio button when clicked to "open" or show 4 text
boxes where you can enter info into the text boxes. Is this possile?

Basically have 2 radio buttons-
1 radio button
2 radio button(when #2 is clicked show the fields below)
Text Box _________
Text Box _________
Text Box _________
Text Box _________

 

[PC Datasheet]

You can make them visible/not visible with the following code in the
AfterUpdate event of the radio button:
Me!TextBox1.Visible = Me!RadioButtonName
Me!TextBox2.Visible = Me!RadioButtonName
Me!TextBox3.Visible = Me!RadioButtonName
Me!TextBox4.Visible = Me!RadioButtonName

Or enable/disable (grayout) them with:
Me!TextBox1.Enabled = Me!RadioButtonName
Me!TextBox2.Enabled = Me!RadioButtonName
Me!TextBox3.Enabled = Me!RadioButtonName
Me!TextBox4.Enabled = Me!RadioButtonName


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

 

[StopThisAdvertising]

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

To the OP: Beware of this guy!!

Steve just does *not* care about the newsgroups. He has *no ethics at all*.
Steve *only* cares about making *money*, and he acts as if the groups are his private hunting ground.

-- He abuses this group and others for job-hunting and advertising over and over again
-- He is insulting lots of people here when they ask him to stop this
-- He posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ??? while asking questions
(the latest 'star's': 'Access Resource' and Tom (e-mail address removed) and Andy)
-- He tries to sell a CD ($125,--) with FREE code he gathered from these groups here
-- There even has been a 'Scam-alert' about him which has been explained recently in the thread 'To all':
http://groups.google.com/group/comp.databases.ms-access/msg/46038ba2954261f9?hl=en
-- Also recently it became clear that he has been spamming innocent people asking questions:
http://groups.google.com/group/comp.databases.ms-access/msg/4f76d0ed3e5f58ad?hl=en

So why would ANYBODY ever trust a person like him and hire him?
********************************************************

Explanation and more links on this answer:
http://home.tiscali.nl/arracom/stopsteve.html

Arno R