Error 2450 making me crazy

[Jim Stanicki]

Rolaaus,
Thank you, sorry about the rant. I do appreciate all the help given here.
I am a bit confused where to put the code you gave me. It looks to me like you are concatenating the the output from the form then opening the form.
Thanks
Jim

 

[rolaaus]

You should be able to put the lines of code in the code box right where your existing docmd.Openreport is at.

however, you will want to write a bit of code in the On Open event of the report that takes the OpenArgs and places them into either a) your controls directly or b) into some variables.

dtBeg = Left(OpenArgs,10) 'use if you are passing MM/DD/YYYY
dtEnd = right(OpenArgs,10) 'this is the simplist for example only.

You may need to actually parse the OpenArgs string for the pipe character | in case single digit months and days come across without the trailing zeros.

 

[Jim Stanicki]

Thank you all for helping me understand.
Jim