>>>>
>
>Hi Brett,
>
>I am displaying a record to printed out from a pageframe form,
>the trouble I am having is in the data environment between the
>form and the report.
>
>The form is setup to print the current record displayed, however,
>when I try to do anything involving the database that contains
>the record for the header info. on the report, I encounter
>errors and crash the system.
>
>I need to print the last record in the 2nd database to provide
>the info for the header info., while at the same time printing
>the record displayed on the pageframe form.
>
>Thanks,
>
>Becky

If it is just header info you need from another table (not the main table for the report) then generate some variables and put that data into the variables before you generate the report. On the report put those variables in the header of the report and you should be ok. Another thing to try is to work the report off of a view or an sql query that joins data from the database and the main table into one non normalized table (header info that repeats for every record in the detail table). Then your report will have the header info in the table it uses for all the detail records.

HTH