Access 2007 Runtime Problem.

[joejack0330]

Just getting into access 2007 runtimes and am having a problem with opening forms when passing parameters from one form to another. We have a main menu and the user selects a facility then if they click on another button, it opens another form which the data source for that form is an sql 2005 stored procedures and the parameter being passed to it is a field off the main menu. This worked fine in 2000 runtime and it works fine if you have full version on access 2007 installed but not in runtime. We get an error "Bad query parameter '@Facility'. Thanks, Joe

 

[Remou]

This appears to include a work-around:

http://www.microsoft.com/communitie...&tid=13e7cbe6-02b9-4df9-b2fc-3eecc8661187&p=1

 

[KORSAKOW]

this link is broken, Can you help me with a good link please?

 

[joejack0330]

I got into it a few weeks ago and never got to really work on it and now it's not working for me either! If anyone has any new links, please post. THANKS!!!

 

[Remou]

At a quick glance, this appears to be the answer to the OP:

http://www.awomantoldme.com/women/how-to/31487484/error-in-runtime-bad-que.aspx

 

[joejack0330]

Thanks a lot, that got me moving forward...until the next problem.

 

[joejack0330]

Some possible good news but who knows when they will actually release this but the do plan an service pack to correct runtime issue...

http://blogs.msdn.com/access/search.aspx?q=runtime&p=1