Command button dis-enabling

[Reaper]

I have a form that is basically a menu of items.



I want to disable some of the buttons based on selections made in a "setup" form. I have the following code in the setup form that has a list of check boxes. When a check box is clicked it runs this code and toggles the "enable" property of the button.

Works great until the user closes the original form and reopens it. Then it reopens with the original enabled settings. It seems that the control property embedded in the control at design time is overriding the code to change it when the form reopens.

Any suggestions?


Private Sub Auditenable_Click()

On Error GoTo Err_AuditEnable_Click

If Auditenable = False Then
Forms!scale_ticket_switchboard.Controls!Audit.Enab led = False
Else:
Forms!scale_ticket_switchboard.Controls!Audit.Enab led = True
End If

Exit_AuditEnable_Click:
Exit Sub

Err_AuditEnable_Click:
MsgBox Err.Description
Resume Exit_AuditEnable_Click

End Sub

[pbaldy]

You'd want the same code in the current event of the form. Or a function called from both places.

[Toyman]

I have a form that is basically a menu of items.

I want to disable some of the buttons based on selections made in a "setup" form. I have the following code in the setup form that has a list of check boxes. When a check box is clicked it runs this code and toggles the "enable" property of the button.

Works great until the user closes the original form and reopens it. Then it reopens with the original enabled settings. It seems that the control property embedded in the control at design time is overriding the code to change it when the form reopens.

Any suggestions?

Private Sub Auditenable_Click()

On Error GoTo Err_AuditEnable_Click

If Auditenable = False Then
Forms!scale_ticket_switchboard.Controls!Audit.Enab led = False
Else:
Forms!scale_ticket_switchboard.Controls!Audit.Enab led = True
End If

Exit_AuditEnable_Click:
Exit Sub

Err_AuditEnable_Click:
MsgBox Err.Description
Resume Exit_AuditEnable_Click

End Sub

When you say the user closes the form and re-opens, do you mean that the user actually exits the db or just closes the form with the db still open. If the db closes, there is nothing you can do. The form will always open to the saved design setting. However, if the db don't close and the user simply closes the form and reopen, then you can assigned the true/false value of "Auditenable" to a public veriable during the closing of the form. You can then set the value from the public veriable to "Auditenable" during the on-load event of the form and then run the Auditenable_Click