Visible Question

B

Bob V

I want to make a control to become Visible if in the third Column of my list
box[lstModify] shows an "e" ,when I select a row I want the control to be
visible
The Control now is set no Visible/No

Me.cmdEmail.Visible = IIf(IsOwnerWithEmail(Nz(Me.lstModify.Column(3), 0)) _
And IsEmailOn, True, False)


Case Else
Me.cmdEmail.Visible = False
-------------------------------------
I have already a togggle button to email or not:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top