>I have a form for posting payments. Once the payments are posted I want to print a receipt. The receipt report is based on a view of the payment table and customer table. I have noticed after a lot of debugging that right before I print the report, I can browse the payment table and the records are updated correctly. If I browse the records of the view .. they have not been updated yet. So I can't print my receipt. What is causing this? Is there something I am not doing correctly?
>
>Thanks,
>
>Paul
Hi Paul,
Might be a foolish question, but are you using the view to post the payments from the form? If so, do a REQUERY() on the view after the TABLEUPDATE(). This should refresh the view with the current table data.
Phil