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
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.