Macro Question

[veder]

I have 2 fields, 1 is Impacted Business, and it is a yes/no field, the second is POC field. What I want to happen is when I am on the form, the POC field is invisable, when I select the checkbox for the Impacted Business field, then I want the POC field to become visable. I tried to write a macro for it, but it doesn't seem to be working. Any help would be greatly appreciated.

thanks!!
veder

 

[WayneRyan]

Veder,

Not a Macro, but do the following:

Get your form in Design View.
Select the CheckBox.
Right-Click and select properties.
Select the Event Tab.

Select the AfterUpdate line.
Select [Event Procedure] from the dropdown.

Click on the three dots at the right.

If Me.CheckBox Then
   Me.POC.Visible = True
Else
   Me.POC.Visible = False
End If

To make it a little nicer, you can put the same code on the
form's OnCurrent event. That way it will display consistently.

Wayne

 

[veder]

thanks!

thanks Wayne!!! Works great now!