Results 1 to 3 of 3

Thread: Urgent! Passing Paramters in data report

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 2006
    Posts
    49

    Urgent! Passing Paramters in data report

    Hi,
    The following is my code which passes parameter to show the report. But on clicking cmdView it displays a complie error saying 'Invalid use of property'.

    Does anyone have a solution to this?

    Thanks

    Code:
    Private Sub cmdView_Click()
     Load DataEnvironment1
      With DataEnvironment1
        If .rsCat_wise_issueM_Grouping.State <> 0 Then .rsCat_wise_issueM_Grouping.Close
        .rsCat_wise_issueM_Grouping (txtCat.Text)
      End With
      rptCat_wise_issue.Refresh
      If rptCat_wise_issue.Visible = False Then rptCat_wise_issue.Show
    
    End Sub

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Urgent! Passing Paramters in data report

    Moved to reporting

  3. #3
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,510

    Re: Urgent! Passing Paramters in data report

    Is this what your trying to do?

    If deCropbyuser.rsCommand1_Grouping.State = adStateOpen Then
    deCropbyuser.rsCommand1_Grouping.Close
    End If
    deCropbyuser.Commands("Command1_grouping").Parameters("param1").Value = frmUrange!txtStart

Posting Permissions

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



Click Here to Expand Forum to Full Width