InputParameter - compatibility 2003 - 2007 issue

R

Roman

Hello!
I have a project .adp under Access 2003 which connects to SQL Server.
There's a table form based on a stored procedure.
Under construtor mode:
record source is my stored procedeure;
Input parameter is
@FIDFILIAL=Forms![Enterprise]![Filials].Form![IDFilial],@DATE=Forms![Enterprise]![CurrentDate]
This table form is built in the main form - "Enterprise".
Under Access 2003 everything works fine, but if I run the same file with
Access 2007, when I load "Enterprise" form, I get prompts for procedure
parameters: @FIDFILIAL and @DATE
What is the reason of this incompatibility and how this could be fixed?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Switchboard buttons stop working 3
InputParameter form property in VB 2
Access 2003 --> Access 2007 code no longer working 6
ADP Parameterized list box query 2
Referncing stored proc from a form 2
Updating Code from Access 2000 to 2003/2007 2
Code works in 2003 not 2007 4
issue with Form parameters 1

Top