My Main Forms name is CheckRegister and on it is a subform named FReg and it is from the subform that the command button is used to open the Report.Reports opens fine, just the Header expression is wrong and gives me the old name error. Here is my code for the expression. it is a textbox.
="Check Reconciliation for
the Time Period of " & [Forms]![CheckRegister]![FReg]![StartDate] & " thru " & [Forms]![CheckRegister]![FReg]![EndDate]
Also, here is the code that runs when thru vba to open the report.
DoCmd.OpenReport stDocName, acPreview, , "([BalDate] Between #" & Me.StartDate & "# And #" & Me.EndDate & "#) And debit>0 And Void <3"
I am guessing this is where the problem is!