Which event to have VBA code to hide fields

[swenger]

I have fields on a form which visible is False if a check box is chosen. I have this code in the "Form Load" event as well as on the checkbox for "On Click" event.

My issue is when I scroll to the next record, even if the checkbox has a check, the code to display and hide certain fields isn't working. I tried adding the code the form event "On Selection Change" as well as "After Update" but it isn't working.



I know I can add this code to the buttons I have for record selection, but then I would have to have it for the previous, next, first and last. Is there an event on the form so that it will work as I scroll through each record.

Thanks,

Sam

[CJ_London]

use the form current event rather than the load event

[swenger]

Thanks. That worked.