Report Parameter in Access Project (.adp)

[TheWebDataGuy]

I am creating an application on Access Project (connecting Access interface to a SQL DB).

I am trying to pass a report parameter using a form but it doesnt' seem to be working right. Conventional means of passing a query parameter using a form (Forms!FormName!ControlName) doesn't work on Access Project becoz the DB is SQL Server.

Has anyone tried such a thing.

Please share your experiences.

Thanks,

 

[lameid]

Well I'm still using Access 97 but for SQL Pass through queries (queries that have the SQL sent directly to the Database Server) I always concatenate the literal criteria in the SQL statement and set the SQL property. I just started to read about ADO but it seems like you should be taking a similar approach.