I have a report that pulls info from a table. When I preview this report, the first page looks correct. The data is the data from the table. But, when I go to see another page, all the rows of data are replaced with only one record from the table. So, if there are 30 rows on the report all 30 are filled with only one rows data from the table over and over and over again.

But, if I put a browse or a suspend before the REPORT FORM line in the data, then close that browse/suspend, the report will run fine.

I have put a select statement before the report from line to see if it just wasn't matching up with the table, but that still doesn't fix the problem.

I have seen this problem before but can't remember the solution.

Thanks for the help.

Troy