Bret,

Thanks so much for the explanations. That gives me more confidence in the way I was thinking, which is exactly what you're saying here. I'll give it a try.


>I dont use data environments. I control all my tables being opened myself, either in the load event of the form or when a specific table/view is needed for some function or display. My theory is this, if the form is a single use form (works on only one table for maintenance or viewing records) then I will open up the database and the table in the load event of the form. If the form will allow the user to view many tables as a multi-use form, I would hold off opening the view until the user requests that info, because they may or may not request a certain view in all incidents of opening the form. So then why would I want to add overhead of opening the views in the load event. Even if I use the NODATA clause there is still overhead. So I will put the code to open the views when the user requests them in mostly the requery method of a list or the activate method of the page.
>
>Here is code I use to check if a view is open in the requery method of a list lets say:
>
>* Set up my parameter
>vp_dmadockey = THISFORM.nKeyToGoTo
>
>* Check if the view is already around
>*
>IF !USED("v_dma_ondockey")
> USE v_dma_ondockey IN 0
>ELSE
> REQUERY("v_dma_ondockey")
>ENDIF
>* Find out how many records we found
>lnTally = _TALLY
>
>ETC....