Running a Macro from Form View

[c stoddart]

Access 2003 Form view _ Using a check Box to return a 5 in a text box. The check box runs a macro

"Private" Sub Check0_Click()  
      If Me. Check0 [= -1] Then  
            Me. Text4 [=+5]
      Else 
              Me. Text4  ""
      End If
End Sub

I get a msg wrong syntax
using an operand without an operator

[MMcCarthy]

Not sure what you are trying to do but your code should look like this ...

Private Sub Check0_Click()  
    If Me.Check0 = -1 Then  
        Me.Text4 = 5
    Else 
        Me.Text4 = ""
    End If
End Sub

[c stoddart]

Thanks, no help. Thanks for your time.

[MMcCarthy]

If you give a little more information maybe we could help.

[c stoddart]

I am trying to run a risk assesment to decide on an audit. Do I use a mailout or onsite. I would like to use a number. The check boxes (5ea)will create a number in the text box. Depending on the final number will determine the action. I need 3 check boxes to be "or" "This one "or" that". Then 3 check boxes will be "Added" to the first boxs' checked.