Jakeman
02-24-2010, 11:41 AM
When I click “print” on a form to run a reports, if report uses a TABLE as the input source it work fine. If click “print” and the report uses a “QUARRY” as the input source, I get a macro error box with “error code 2950”. Why & how can I eliminate this problem?
Thanks for any solution!
pbaldy
02-24-2010, 12:01 PM
What is the description for that error? I don't use macros, but all my reports are based on queries, and I don't have any problem printing them.
Jakeman
02-24-2010, 12:37 PM
Here's picture of the error message:
pbaldy
02-24-2010, 12:44 PM
What does the wherecondition look like in the macro itself? I think in a macro you don't need to concatenate the parts together like you do in VBA. If you want to do it in code, it looks like this (with OpenReport instead of OpenForm):
http://www.baldyweb.com/wherecondition.htm
Jakeman
02-24-2010, 01:02 PM
It does says this:
under "Action" = OpenReport
under "Arguments" = Quilt Est Work Order Rental, Report, , ="[ID]=" & [ID], Normal
pbaldy
02-24-2010, 01:08 PM
Like I said, I'd use code rather than a macro, but in macro help it says the where condition argument should look like:
[fieldname] = Forms![formname]![controlname on form]
No quotes or ampersands.
Jakeman
02-24-2010, 01:14 PM
Thanks for your time & help!!