I have a form that has a listbox on it and a button that says generate report. When I amke a selection and click the button it run a sub that is posted below.
Private Sub BMLreport_Click()
On Error GoTo Err_BMLreport_Click
Dim stDocName As String
stDocName = "rptBMLAgreementSummary"
DoCmd.OpenReport stDocName, acPreview, "qryBMLReportQuery", "[BusinessName Field] = '" + List1.Value + "'"
When I click the button if gives me the following error " The Specified field '[tblMain-Link].Active' could refer to more than one table listed in the FROM clause of your SQL statement.
That being said if i go and open the query and run it manually it does show up with alot records without giving a single error.