[AccessD] Invalid Reference to the Property Form/Report

Having inconsistent versions of ADO between machines can cause all sorts
of bizarre problems.  Have you made sure that the latest MDAC installer
has been run on all the machines?

Charlotte Foust

-----Original Message-----
From: Susan Geller [mailto:sgeller at cce.umn.edu] 
Sent: Monday, July 28, 2003 7:48 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Invalid Reference to the Property Form/Report


I have an application and I'm testing the new release and suddenly
getting an error in a place where I did not get one in an older version.
And, I'm not getting it on the development machine, only on test
machines.  

On a report, in the Private Sub PageHeaderSection_Format code, I have:

Dim ctl As Control
Dim strDescr As String
Set ctl = Forms!frmWiz!SubCrit!lstTerm
strDescr = BuildReportHeaderString(ctl, 1)

The code runs fine when the report first opens in preview mode.  But,
when I try to preview page 2 or any subsequent pages, I get this
message:

"You entered an expression that has an invalid reference to the property
Form/Report".  When I step through the code, the error is in setting
ctl.  I tried getting rid of the ctl reference and instead used just:

strDescr = BuildReportHeaderString(Forms!frmWiz!subCrit!lstTerm, 1)

But I get the same error message at this line.  References are ADO 2.7
library.  

I am at a total loss.

--Susan






Susan B. Geller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com