input popup only in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 prompting me to 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
 
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 prompting me to 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.
Click to expand...
are this linked tables?

paste the SQL-String into the Query-Designer
does it ask also?
 
Back
Top