Query criteria referencing field name no longer works
From: Matt (anonymous_at_discussions.microsoft.com)
Date: 04/30/04
- Next message: tina: "Re: Test for no records returned"
- Previous message: John Spencer (MVP): "Re: Compare 2 table & show detail both table"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: tina: "Re: Test for no records returned"
- Previous message: John Spencer (MVP): "Re: Compare 2 table & show detail both table"
- Messages sorted by: [ date ] [ thread ]