Thanya,

Not stupid, just lack of experience.

If you open your view with USE, you need USE MyView NODATA.

You're probably putting the view in the data environment though. You need to set the property of the view to

DataEnvironment.Cursor.NoDataOnLoad = .T.

When the form is entirely loaded you can REQUERY to get all the data, or have the user enter a parameter and just retrieve the data you need.



>Hi Cindy,
>
> This is kinda stupid of me but I don't know how(and where) to use "USE MyView NODATA"? Please, tell me more about it.
> Thanks for a million.
>
>
>>The "Executing Remote" wait window is what you see while you're form is >filling some remote view with data. It takes the minutes to retrieve all of >the data from the server.
>
>>What you probably need is to USE MyView NODATA so the form will open right >away, and then ask the user which records to retrieve. (This would mean you >would need to use a parameterized view.)