Toggle Button to hold last choice

[Bob Vance]

I have a toggle button that either allows or stops the report from being
emailed, but if I close my database down it will not hold my last choice
tblAdminSetUp.Mailflag is a yes/no field
Any help please....Thanks Bob

Private Sub cmdSendMail_Click()
If cmdSendMail.value = True Then
cmdSendMail.Caption = "Send Email"
Else
cmdSendMail.Caption = "Do Not Send Email"
End If
CurrentDb.Execute "update tblAdminSetup set MailFlag = " & cmdSendMail.value
End Sub

 

[KARL DEWEY]

Have you considered using Set Value on the Default of the button?
Another way is to create a table with one field and one record and use an
update query.