Marco error 2950

[Jakeman]

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]

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]

Here's picture of the error message:

 

[pbaldy]

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]

It does says this:
under "Action" = OpenReport
under "Arguments" = Quilt Est Work Order Rental, Report, , ="[ID]=" & [ID], Normal

 

[pbaldy]

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]

And no = before it all.

 

[Jakeman]

Thanks for your time & help!!

 

[PatrickPetranech]

Paul,

I know this thread goes way back, but would let me know the profile event trigger you place your code for "Open a second form to the record selected on the first form" into. This goes back to 2/24/2010

 

[pbaldy]

Whatever event you want it to be in. It could be the click event of a button, the click or double click event of a textbox, etc.