>Many thanks Jeff,
>
>How do I properly declare my variables within the form's event code so they can be visible from the report writer. I've tried declaring them as public in the form's load event but that didn't work.
>
>Stephen
Since I don't have your code, I'll try to be generic. Public is considered bad practice by most, but that is an option. Depending on how many you have you can declare them private in the method you use to call th report. Like in the click of a command button.
Private var1
Var1 = whatever
do report.......
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com