And If???

[petercummins]

Is it possible to do something along the line of:-

if [combo box(1)] = "Y"
and if [combo box(2)] = "Y"
and if [combo box(3)] = "Y"
then
[Total] = "100"

Not sure if you can do it this way but im sure you guys will know a way round it!

 

[ColinEssex]

If Me.combo box(1) = "Y" and Me.combo box(2) = "Y" and Me.combo box(3) = "Y" Then
Me.Total = 100

End If

 

[petercummins]

Thanks Colin that worked a dream!