Send email with report as an attachment

[DJRhino1175]

Dang it, Now I'm having issues with my reports. It keeps Telling me to:
Enter Parameter Value ECN#

But I change these in everything. Tables open up fine, queries open up fine, Forms open up fine, but not any of the reports....I can feel my hair turning grayer...

[twinnyfo]

If it is in a control, then you can use it. just use Me.[Name of the Control] in your VBA.

Do you understand that you have to get the value of ECNID into the Filter. Since I don't have your DB in front of me, I am unable to click around and determine your structure and the names of all your controls.

Understanding how to reference objects and controls in your VBA will great dividends for you in the long run.

Please forgive us if we take some of these things for granted.

[twinnyfo]

Somewhere in your report there is a refeerence to the ECN# instead of the ECNID. Is it being sorted by that field, perhaps? this will sometimes cause such an error even after you have changed all your controls.

[DJRhino1175]

I'm sending it to my house laptop so I can see if I can fix it with out any interruptions.. .

[DJRhino1175]

I think I got it working completely now. Once I went through all my reports and fixed the sorting and grouping, I gave the code a try as it is and it seemed to work. As a matter of fact I tried it multiple times and it worked every time.

Thanks twinnyfo, Its a good thing you are very patient, I can be tough to straighten out...

[twinnyfo]

That's awesome! I'm glad we could get this working for you.

On to the next project, eh?