View Full Version : Marco error 2950


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.

SOS
02-24-2010, 01:13 PM
And no = before it all.

Jakeman
02-24-2010, 01:14 PM
Thanks for your time & help!!