setting input parameters without opening the form in design view

[Zirak]

I am using a SQL backend with an Access front end.
i need to programmatically pass some parameters to it.
I tried to do it by opening the report in design veiw and passing the input parameters. It works however the problem is that I won't be able to open the form in design veiw if I have a ADE project.

Is there any other way to pass a parameter to an Access Project report?

 

[jdegeorge]

Zirak

I have a similar problem where I want to pass multiple paramters to a report. I posted this thread: thread703-609559 don't have an answer yet, but mark this post to see if I ever get an answer. Or, maybe my progress so far, which works for 1 or 2 variables, is sufficient to solve your problem. Hope this helps.

Jim DeGeorge

 

[Zirak]

Thanks for your reply.
I actually have it working for a couple of parameters, but in some cases I face wierd errors.

Thanks