locked
Enter parameter value "0" and "#" RRS feed

  • Question

  •  

    When this case opens my report I am getting this error

    Enter Parameter value 0

    Enter Parameter value #

    Then my report opens fine, Thanks for any help...Bob

    Case "PaymentMethod"

                Me.Caption = "Payment Method"

                If Form_frmBillStatement.fraCreditType.value = 1 Then
                    strSQL = "Select * from qryPaymentMethod where BillID>0"
                ElseIf Form_frmBillStatement.fraCreditType.value = 2 Then
                    strSQL = "Select * from qryPaymentMethod where BillID< 99999999999999999999"
                End If
                tbInvoiceNo.Visible = False
                tbOwnerName.Visible = False
                tbHorseName.Visible = False
                tbAmount.Visible = False
                tbDueAmount.Visible = False
                tbInvoiceNo.Visible = True

                tbBillID.Visible = True
                tbBillID.ControlSource = "CreditNo"
                tbDate.ControlSource = "BillDate"
                tbDueOwnerName.ControlSource = "OwnerName"
                tbPaymentMethod.ControlSource = "MethodOfPayment"
                tbAmountPaid.ControlSource = "PaidAmount"
                tbInvoiceNo.ControlSource = "BillId"
                tbSumOfAmount.Visible = False
                tbSumOfAmount.ControlSource = "PaidAmount"
                lblInvoices.Visible = False
                lblTotal.Visible = True
                tbTotal.Visible = True
                tbCreditType.Visible = True
                tbCreditType.ControlSource = "CreditTypes"
        End Select

                              
    Sunday, September 21, 2014 1:51 AM

Answers

  • Found it there was a zero and a hash in the 2 text boxes control sources, how does that happen!

    Thanks anyway Bob

    • Proposed as answer by George Hua Monday, September 22, 2014 5:27 AM
    • Marked as answer by Luna Zhang - MSFT Tuesday, October 14, 2014 1:35 AM
    Sunday, September 21, 2014 2:47 AM

All replies

  • They are 2 text boxes that another case uses, how do I get this case to ignore them....Thanks Bob
    Sunday, September 21, 2014 2:35 AM
  • Found it there was a zero and a hash in the 2 text boxes control sources, how does that happen!

    Thanks anyway Bob

    • Proposed as answer by George Hua Monday, September 22, 2014 5:27 AM
    • Marked as answer by Luna Zhang - MSFT Tuesday, October 14, 2014 1:35 AM
    Sunday, September 21, 2014 2:47 AM