Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    36

    Unanswered: "Enter parameter value" popup when I try to filter

    Hi all,

    When I try to filter my report through input into a form, I get a pop up box that says "Enter parameter value" when I click on the button to filter the report. Has anyone experienced this before?

    Regards,
    Swee

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    It may be due to, that your form runs a query which needs its data from text filed on your Form, so you must fill this text field with suitable data

  3. #3
    Join Date
    Aug 2004
    Posts
    36
    I think it might be my code that could be the problem.
    Code:
        Dim strACCode As String
        Dim strFilter As String
    
        ' Build criteria string for A/C Code field
        If IsNull(Me.txtAccCode) Then
            strACCode = "Like '*'"
        Else
            strACCode = "='" & Me.txtAccCode & "'"
     '       "='" & Me.cmbReference.Value & "'"
        End If
    
        strFilter = "[Report]![RptLookupRecords].[Report]![SubFrmLookupRecords]![Acc_Code] " & strACCode
    
        ' Apply the filter and switch it on
        With Reports![RptLookUpRecords]
            .Filter = strFilter
            .FilterOn = True
        End With
    I think the line bolded above could be causing the problem. Or is it something else?

    Note: RptLookupRecords is the report that I want to filter and SubFrmLookUpRecords is a subreport inside that report.

    Thanks a lot,
    Swee

Posting Permissions

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