>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,

It would have been helpful to give more than the error number - full message and the offending line might mean more than just number.

So, let's take a general shot in the dark - 'Cannot access selected table' usually means you had a combo with alias or fields rowsource, and it was closed meanwhile, and you got this error when it tried to requery or refresh. Check the rowsources of your listboxes and combos, and in the debugger put a watch on used('{your row source alias here}'), and see if any of them close while you run the reporting. Another reason may be programmatic switching of datasessionIDs - if your cursors are open in DS 2 and running the report returns you with DS 3 active, you may get this message even if everything is still regularly open, but not in the current DS.