>thanks all.
>
>I think this will work.
>
>What about reports that reference the the calling form.
>
>do form xx namd xx linked
>the user clicks a button for the report and how do we reference back to the form for something like this.
>
>Such as xx.txtdate.value
>
>TIA
>shawn
If you do not use a Private DS in the report, you could just use the open table or cursor your form is using. In general I have a form that sets up all my reports, and my reports use the DS of that form. My form does a REPORT FORM MYREPORT PREVIEW [or TO PRINTER NOCONSOLE]. The form is using a private DS. The fields on the report do not use data values from controls. The data is derived from the tables and views. In the RunReport method, I will initialize some LOCAL variables which can be seen and used by the report.
Mark McCasland
Midlothian, TX USA