Visible Image if 2 checkboxes are true

[connordrew]

Hi,

I have three checkboxes on my form and I would like to set the following properties:

I have an MP3, a WMA and Logged field.
If logged = yes and either wma or mpr = yes, then I want a play button to be visible.

I have tried using the following code:

Private Sub Form_Current()
If Me.checkboxname = True Then
Me.commandbutton.Visible = True
Else
Me. commandbutton.Visible = False
End If
End Sub

But this will only allow for 1 checkbox. Can anyone help?

 

[KenHigg]

If Me.checkboxname1 = True and Me.checkboxname2 = True Then
Me.commandbutton.Visible = True
Else
Me. commandbutton.Visible = False
End If

 

[connordrew]

Thanx Ken,

I will give thata try and let u know how I geton.

 

[connordrew]

Thanx Ken,
Worked perfect. Also, I successfully managed to modify it a bit so that if logged = yes and either wma or mp3 = yes, then the play button would be visible.

Private Sub Form_Current()
If Me.Logged = True And Me.WMA Or Me.MP3 = True Then
Me.PLay.Visible = True
Else
Me.PLay.Visible = False
End If
End Sub

Thanx again m8

 

[KenHigg]

Cool -

fyi - You may want to paren these:

If (Me.Logged = True) And (Me.WMA = true Or Me.MP3 = True) Then

Ken