Form_load / New record Question?

[Jester1147]

So here is my question...

Using a form_load and if/then for enabling/disabling some fields depending on if a particular checkbox is checked... is there a way to have this process reset after a new record loads? Currently if checkbox A is selected, fields 1,2,3 and 4 can be filed (using the AfterEvent() ). But if i go to the next record, even tho checkbox A is not selected, the fields are still open because of the previous record updates.

Is there a record_load function that will work the same as the form load?

Thanks

 

[vbaInet]

Apply your logic in the On_Current, After_Insert and After_Update events of the form.

 

[JANR]

Use the form's Current event.

Private Sub FormName_OnCurrent()
Me.ControlName.Enabled = Me.CheckboxA
Me.Controlname2.Enabled = Me.CheckboxA
... and so on
End Sub

JR