Re: A2003 prompts for query parameter values...

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 18:31:11 -0500

Is it possible that the field name somehow got changed from appID in
qryHierarchy? 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Raja" <Raja@discussions.microsoft.com> wrote in message 
news:0BF8F2AD-30C0-435D-ADC0-A8A0348C8A01@microsoft.com...
>I have an Access database application that was written in Access 2000. I 
>have
> converted the database to Access 2003 format. When I run the applicaion in
> Access 2003 it is prompting me to enter value for all the "WHERE" clause
> values in any query.
> For e.g. when it executes the following line
>
> Me.RecordSource = "Select * from qryHierarchy where appID=1"
>
> I get a popup box to ask me enter appID, though I have hardcoded appID=1. 
> It
> is the same case for all queries in my application. This application works
> well in Access 2000 and Access 2002 (SP2). It does not work in Access 2003
> and Access 2002 (SP3)
>
> Does anyone have any idea about whats going on here...
> Thanks in advace for your help.
>
> Regards,
> Raja