General information
Category:
Coding, syntax & commands
>>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
Hi Phil,
I am updating tables actually. I do a requery in the form that updates the payment table. I just now tried to browse the records right after the requery and I see that the records in the view are updated correctly. Now when I create an instance of my report class with createobject and browse the records of the view they aren't udpated correctly. I guess I don't understand what the requery is doing exactly. Does what I say is happening make sense?
Thanks,
paul
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only