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