Access asks for parameter when I already defined parameter

[Krash878]

I have a form that is supposed to open a report.

For some reason I get a pop up that asks for a parameter in the dialog part and has the parameter already entered in the grey part above the textbox. This pop up is access created and I do not know how I got it to apear there. Here is the code behind the command button

rivate Sub btnBillingChargeBackInvoiceSingle_Click()
On Error GoTo Err_btnBillingChargeBackInvoiceSingle_Click

Dim stDocName As String

stDocName = "rptBillingChargeBackInvoice"
DoCmd.OpenReport stDocName, acViewPreview, , "WSBAPNo =" & Me![txtWSBANo]

Exit_btnBillingChargeBackInvoiceSingle_Click:
Exit Sub

Err_btnBillingChargeBackInvoiceSingle_Click:
MsgBox Err.Description
Resume Exit_btnBillingChargeBackInvoiceSingle_Click
End Sub

Thanks

Krash

 

[scking]

Is rptBillingChargeBackInvoice based on a stored query? If so simple run the query independently and it should squawk for what it needs. Look closely at the design the trouleshoot the issue. In a large preponderance of the cases there is a typo in the query design. You might even open the SQL view for the query and look closely at the result.

Steve King

Growth follows a healthy professional curiosity

 

[Krash878]

Thanks