Changes still in effect when going to a new record 1

[Chris1977]

Hey Folks,

I have hidden fields on a form which are activated when an option button is clicked, turning their visible property to true.

The problem is when i go to a new record the fields i made visible in the previous form are still visible when they shouldn't be.

Is there code i can put on the form so that everytime i go to a new record or one with data already on it the fields are visible.false as they should be until activated by clicking the option button?

Thanks in advance,
Chris

 

[SgtJarrow]

Sure....in the OnCurrent Event of the form put code to check the option button...

If Me![OptionButtonName] = True Then
Me![field1].Visible = True
Me![field2].Visible = True
....
Else
Me![field1].Visible = False
Me![field2].Visible = False
....
End If Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: mstrmage@tampabay.rr.com

 

[Chris1977]

Robert,

Thanks for your help...........i really appreciate it.

Chris