>>Is it possible to requery a local view within a transaction. I know the syntax Requery("MyLocalView") doesn't work, but is there another possibility?
>>
>>W. Dieke
>
>As Jim stated, this won't work- but perhaps more importantly, why are you trying to do this? Transactions should only wrap update procedures, and not much (if anything) else. Trying to get data from a table inside a tranaction looks like a bad design choice...


I have a form which starts with a Begin Transaction. In this form I lock one record. In my local view I have a filter which is a field from my locked table. When I change the filter, I wan't to requery my local view. I wan't to make changes to my local view.