B
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
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