Hello,

I am not sure if this is a SQL-select problem or a form problem. I have a form based on a view in VFP 6.0, SP5. This view also has several child views and child forms. I have a complex report that I print from the underlying table and child tables, using several layers of SQL-select into temporary cursors, and, finally pulled together with sql-select into a table on the local hard drive, used for printing, and then deleted.

If I add a new record to the form, and also add the required records in the child forms, the report runs fine, AS LONG AS IT IS THE FIRST TIME I HAVE RUN THE REPORT SINCE I OPENED THE PARENT FORM. Once I print the report, if I add another record to the parent and child forms, and save it, the report on the new record will not print. The last step of pulling the temp cursors into the table to print gives me nothing in the table, but the temp cursors are all populated. I can still move to other existing records in the form, and print the report from them just fine. It is only the new record that won't print (and that only if it is the 2nd or later print since the form was opened).

If I close the form, and reopen, then the new record I had added is treated as an existing record and I can print it at will. This problem does not happen with any existing records. I can print as many reports as I want from existing records. It only happens on new records after a report has already been printed since the form was opened.

I have tried everything I can, including requeries, refreshes, etc. Nothing seems to work. Is there anything anyone can suggest?

Sincerely,

Jerry Brunet