VBA only works on initial opening

[Ilovexfiles]

Hello
I have for example, If statements that are based on the selection of a field and depending will grey out/disable other fields.

If the user is entering on the form for the first time it works, but when they reopen (a hyperlink that opens the same form for that record) to make edits or add information, the the greys out/disabled fields are working again unless the user goes back and reselects it.

It is possible to have the the fields maintain the greyed/disabled mode even upon reopen?

 

[isladogs]

Sounds like the form stays open so the form open/load events aren't firing again.

If so, do one of these
1. ensure the form is closed before the user returns to it
2. Add the code which disables various controls to form activate event

 

[Ilovexfiles]

Activate worked, thank you!!!