Macro for Visable

[CEH]

I am trying to do a form for crieria to a query. Three option buttons. When you click one of the buttons on I want the text boxes to enter the criteria to become visable. I will set the properties of the text boxes to Visable..No.
What do I set the macro to? I tried setvalue, but it doesnt seem to work correctly. Anyone know?
Thanks

 

[trucktime]

Macro

No need for a macro to do this.
In fact, try to stay away from macros all together since you cannot do
error trapping using them.

In the On Click Event of the button put something like this:

Me.textboxname.Visible = True

 

[CEH]

Works......but.....

That works fine using "got focus" and "lost focus"(there is no "on click" it is a radio button) But........ you can not click inside the new boxes????? Don't get that...... I am thinking of using a subform with the "visible" feature. Are there any tricks to that? Or is it the same... "ME.Subformname. visible = true" ???


Thanks