Link to home
Start Free TrialLog in
Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America

asked on

dcount - type mismatch

Help with syntax - getting type mismatch on last half of string

Need record count of ReqNo where checkbox (Reviewed...) is true per ReqNo.

Private Sub Reviewed_With_Question_AfterUpdate()
   Dim x As Integer
   Dim nReqNo As String
   
   nReqNo = Me.ReqNo
   x = DCount("ReqNo", "UseCases", "ReqNo =" & nReqNo And [Reviewed With Question] = True)
    If Me.Reviewed = True Then
        Me.Reviewed = False
    End If
    If x > 0 Then
         [Forms]![RequirementsReview]![Reviewed With Question] = True
    Else
         [Forms]![RequirementsReview]![Reviewed With Question] = False
    
    End If
   [Forms]![RequirementsReview]![DateModified] = Date
    Me.DateModified = Date
    Me.Repaint

End Sub

Open in new window

Thanks,  What am I missing.
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

x = DCount("ReqNo", "UseCases", "ReqNo =" & nReqNo & " And [Reviewed With Question] = True)
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Karen Schaefer

ASKER

Thanks Rey that did the trick.

K
Thanks Rey that did the trick.

K