Query criteria referencing field name no longer works

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

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.
 
Hi Matt,

What is
[Forms]![frmTabsControl]![sfrGeneral]![sfrEventsLog]![JCN]

Should the syntax should be something like (guessing it's a subForm
control):

Forms![name of Form]![name of subForm control].Form![text box control
on subForm]

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "Matt" <[email protected]>
| Sender: "Matt" <[email protected]>
| Subject: Query criteria referencing field name no longer works
| Date: Thu, 29 Apr 2004 18:17:24 -0700
| Lines: 10
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQuUOTBa1DrOsrVRz6ev/jZ/+2iXQ==
| Newsgroups: microsoft.public.access.queries
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.queries:199125
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.access.queries
|
| 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.
|
 
Back
Top