Query criteria referencing field name no longer works

From: Matt (anonymous_at_discussions.microsoft.com)
Date: 04/30/04


Date: Thu, 29 Apr 2004 18:17:24 -0700

I have a query that uses another form's field value as
criteria. This field criteria worked in Access 2000 and
2002. But, does not work in Access 2003. It prompts me
for the field value. Has the syntax changed?

SELECT tblScheduler.* FROM tblScheduler WHERE
(((tblScheduler.JCN)=[Forms]![frmTabsControl]!
[sfrGeneral]![sfrEventsLog]![JCN]));

Any help would be appreciated.