Access 97- if... and if... then Coding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jeschaefer@usa.net - 12 Jul 2007 14:43 GMT

I usea form with check boxes. I have code that If one box is checked
Then change a list to "1"

Private Sub XXX_AfterUpdate()
If (Me.XXX = -1) Then
Me.List117 = "1"
End If

I want to write a code that if two (or more) boxes are checked Then
change list to 2

Private Sub XXX_AfterUpdate()
If (Me.XXX = -1) and
If (If Me.YYY = -1 ) Then
Me.List117 = "2"
End If

I would appreciate any help.

Reply to this Message

Jeff Boyce - 12 Jul 2007 17:03 GMT

Have you checked Access HELP for the syntax on the If...Then function?

Perhaps:
If (Me!XXX = -1) And (Me!YYY = -1) Then
'do this
Else
'do that
End If

Regards

Jeff Boyce
Microsoft Office/Access MVP

>I usea form with check boxes. I have code that If one box is checked
> Then change a list to "1"
[quoted text clipped - 14 lines]
>
> I would appreciate any help.

Reply to this Message