Check box to trigger event

[poetdi]

Hello - this should be really simple but I'm out of practice. I've tried using a macro as follows:
I have a form with a checkbox. I'd like, when the user checks the box, for another box to appear. I have that box set to invisible.
I created a macro, and all it is supposed to do is change the property of the box to visible. I've assigned that macro to the On Click event of the checkbox.
When I check the box I get the following error:
"An expression in argument 3 has an invalid value.
You tried to run a macro or used the DoCmd object in Visual Basic. The argument number above is the position of the argument as it appears in the Macro window, the Action Failed dialog box, or the Object Browser (if you're using the DoCmd object)."
When I clear that message, I get the Macro Single Step dialog box which lists the macro name, a blank condition box (because there aren't really any), the Action Name (which is SetProperty) and the Arguments box, which has the name of the field I want to make visible, then the number 1.
The error number is 2505.
All I want to do is have the user check the box, and make this box appear. Otherwise, I don't want the box to appear.
Any suggestions welcome. I feel like a very silly person but, oh well!

 

[boblarson]

The easiest way is to not use a macro for this but use VBA. It is easy - in the event property of the checkbox (use the After Update event) you select [Event Procedure] from the drop down and then click the Ellipsis (...) to the right of it. It will open the VBA window to the code like this (I am using MyCheck as my checkbox name. Yours would be whatever it really is):

Private Sub MyCheck_AfterUpdate()
   Me.MyTextBoxNameHere.Visible = Me.MyCheck
End Sub

So it will show if it is checked and not if not checked. You will also need to call this code in the form's On Current event. You can do that by going to the form in design view (from being open) and then in the On Current event you select [Event procedure] and click the Ellipsis (...) like before and then put

Private Sub Form_Current()
   MyCheck_AfterUpdate
End Sub

The only thing you would replace is your actual checkbox name for MyCheck. Everything else stays the same.

 

[poetdi]

Bob - thank you - it worked beautifully. Thank you so much. Have a great week!!
Diane