Parameter Form Error

[Laurie]

I have checked the all the posts and can't find an answer to my issue. I
have an unbound parameter form that I run several different reports from.
The form has 1 unbound combo box for the manager's name, an unbound box for
the start date, an unbound box for the end date and a comand button to run
the report. The parameter form was working okay and I was able to run
reports but now when I try to run the reports I get the following error.

The record source '~sq__cParamForm~sp_cFindMgr' specified on this form or
report does not exist.

I have checked all of the spelling in the fields and everything is still the
same as when it was working. My row source for the field on the parameter
form is: SELECT"All" As MgrName FROM tblMain UNION SELECT MgrName FROM
tblMain ORDER BY MgrName. I have named the field FindMgr. The control
source for the report fields is set to MgrName.

This is the code I have for the form:

Option Compare Database
Private Sub Command7_Click()
Me.Visible = False
End Sub
Private Sub Detail_Click()
End Sub
Private Sub EndDate_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub FindMgr_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub Form_Load()
End Sub
Private Sub StartDate_BeforeUpdate(Cancel As Integer)
End Sub

And this is the code I have for the reports:

Option Compare Database
Private Sub Report_Close()
DoCmd.Close acForm, "ParamForm"
End Sub
Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "ParamForm", , , , , acDialog
End Sub

Hope I have provided enough information.