>Using VFP7.
>
>I have a view that I place in the form's data environment.
>
>In the form's Load(), I Set Deleted On.
>
>When I run the form, the view is created but it shows deleted records. The only way I see around this is to issue a =Requery([myview]) in the Init().
>
>How can I avoid querying a view twice when the form starts up to remove deleted records from the view?
>
For forms with DE you should put all your SET commands into BeforeOpenTables event.
--sb--