Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    99

    Unanswered: If Statment for Multiple checkboxes resulting in cost

    Not sure why this is not working have tried several different Variations

    The Yearly Permit Plus Payscalebelow is working and gives the correct cost of 50 but the sixmonthly and payscalebelow always calulates at 0.00

    Any suggestions would be Appriciated Thank you

    Private Sub PayScaleBelow30122_AfterUpdate()
    If (Me.sixMonthlyPermit And Me.PayScaleBelow30122) = True Then
    Me.Cost.Value = "30"
    Else
    Me.Cost.Value = "00"
    End If
    If (Me.YearlyPermit And Me.PayScaleBelow30122) = True Then
    Me.Cost.Value = "50"
    Else
    Me.Cost.Value = "00"
    End If
    End Sub

  2. #2
    Join Date
    Feb 2013
    Posts
    99

    Resolved

    Worked it out

    If (Me.sixMonthlyPermit And Me.PayScaleBelow30122) = True Then
    Me.Cost.Value = "30"
    ElseIf (Me.YearlyPermit And Me.PayScaleBelow30122) = True Then
    Me.Cost.Value = "50"
    Else
    Me.Cost.Value = "00"
    End If

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •