Check Boxes

[CLSkcab]

Background- Foreground MS Access 2010; Background MS SQL Server 2008; this program is written in Access/vba.

On a form I have a check box field. When the check box is checked (true) how do I turn on the visibility of certain fields below it? See attached.

[jimatqsi]

You can put code in the OnUpdate event of the checkbox if you want to change properties of some objects after the checkbox is changed.

If you want to change properties of some objects after navigation, put your code into the form's OnCurrent event.

Best option is probably put the code in a subroutine and call that subroutine from both events.

Jim