parameters for access project

[MMSJED]

There is one query in my access database project depend on Parameter in
running from a form
For ex. Called Form1 and the Parameter called IdNo
When I was using the access database (.mdb or . accdb ) I was setting the
criteria like this
[form]![[form1]![IdNo]
When I try to convert my file to access project (.adp) this criteria is not
working anymore and give sql error msg
So please how to set criteria like this in access project (.adp) views or
queries
Your help will be appreciated

 

[Sylvain Lafontaine]

Hi, the official newsgroup for ADP is microsoft.public.access.adp.sqlserver.
By taking a some previous posts in this newsgroup, you will find a lot of
answers to many of your questions.

In your case, you can either dynamically build a sql string to be used as
the record source of your form or use the InputParameters property:

http://groups.google.ca/group/micro...r/search?q=InputParameters&start=0&scoring=d&