Results 1 to 2 of 2

Thread: Data refresh problem

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Sep 2006
    Posts
    236

    Data refresh problem

    This has got to be really simple but I don't know how it's done. I have a program that saves the data from a form to a table - only the data from that particular form is saved in that table - no other data. There is only 1 record in that table which is only the current data that I wish to print. IOW, it's simply a temporary holding table for the report. After the data is saved I call the report. This works fine - all data from the table is shown on the form as I designed it. However, if I close the report and modify the data on the form and then save the changes to the table and open the report once more, the report only displays the old data - not the updated changes. I've checked the table to be sure the changes have been saved.

    How do I force the report to refresh the data each time it's opened?
    TIA
    Ken
    Last edited by SparrowHawk7; Jun 23rd, 2007 at 08:38 AM.

  2. #2

    Thread Starter
    Addicted Member
    Join Date
    Sep 2006
    Posts
    236

    Re: Data refresh problem

    I neglected to mention this is CRXI from VB6. The save data with report is NOT checked. When I enable the refresh button on the report I find I must click it TWO times before the data is actually updated regardless of how long I wait. I've tried closing the database before calling but that has no effect, nor does a runtime refresh command.

    There are quite a few variables (this is printing an invoice) but I suppose I could pass them directly to the report if nobody has any ideas.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width