>Dear All,
>
>I attempt to design a form which a stock system hold the stock description and a grid hold a local view of transactions table. In the form I can print the transaction report of the item by clicking a 'Print' button, which select SQL commands is coded to select the item informations from the transaction table and put to report (report form.....).
>
>While I have other form to print all reports by releasing the stock form and do form 'report page'.....
>
>When everytime I return from the print routine, and atempt to go to the report page. The system generate a error code # 1152,
>
>What happen to the problem and how to fix the above problem??
>
>With regards,
>
>Ransome
First, at Help, Technical Reference -> Error Message -> Error in Number form..
You can check out the detail meaning of 1152.
Try a data out of 32k or attempt to reference a data which the table not yet opened.
I suggest you add 1 line of code before open the view:
Select 0 && New work area or add bold below to ensure open table in new area.
Use myDatab!myReportView
again in 0Select myReportView
....
Another possible case as Jos said, you may change the value of Data environment in reports.
AutoCloseTable should be .F.
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.