>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
Hi Paul,
Sorry to get back to you so late. Got quite busy most of last week. I cannot think of anything off hand. If the view is being requeried, you should see the current state of the table through the view immediately after the Requery() statement.
Might sound like a dumb question, but is there anything in the filtering of the view, or its SQL statement, that might be causing it to ignore the new or updated records?
Phil