[AccessD] Query difference between Access 97 and 2002

Barbara Ryan BarbaraRyan at cox.net
Tue Aug 9 14:20:20 CDT 2005


I have converted an Access 97 application to Access 2002 (XP).  A query that works in 97 will no longer work in XP.  The  field in the query causing the problem is referencing an unbound text box on an open form, i.e., the field name in the query is "PeriodEndDate:[Forms]![frmPerDiemEntry]![txtPeriodEndDate]".  When I execute the query in 97, I see the contents of txtPeriodEndDate; however, in XP, it is blank/null.

Any ideas?

Thanks,
Barb Ryan


More information about the AccessD mailing list