I have a .mdb with a form that allows the user to select criteria, then it saves the results as a qry to use as record source for a report. The report uses the caption property of the form as the caption on labels in the report header. Both the form and the report run, (or at least they appear to) however, when I try to compile I get a runtime error 2450 "database can't the form "frmpracticeresults referred to in macro or vb code".

I have the following code in the on activate and on report header print events and it scores the same error (2450)on each one of them (but RUNS when I launch from the form).

Reports![rptpracticeresults]![lblSortSpec].Caption = Forms![frmpracticeresults]![lblSortSpec].Caption

I've checked my spelling and frmpracticeresults is present and it runs. Am I perhaps in the wrong event, or did I call it wrong? Or something else?
Any help is much appreciated. I want to get this thing compiled so I can see if we can benefit from splitting.
Thanks,

Loralee

Put this on the report's header's ON FORMAT event, not in the report's ON ACTIVATE event:

Me.lblSortSpec.Caption = Forms.frmPracticeresults.lblSortSpec.Caption


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

If that doesn't work, add an extra .Form property, that is...

Me.lblSortSpec.Caption = Forms.frmPracticeresults.Form.lblSortSpec.Caption


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks, Greg.

I'll give it a try this week end.
Loralee

Greg,
It looks like just moving the existing code to the Report Header's on FOrmat event, like you said, (and removing the code from the other 2 events) took care of the issue.

THANK YOU very much.

Loralee