You may want to take a look at not opening the tables until they are needed. What it sounds like is that you have several tabs that all load their respective data when the form comes up. Instead, think about waiting to load the data until the user clicks on the tab. That is a trick I learned way back, and one that a lot of applications use.

Some frameworks have the ability to delay instantiation of the information on the tabs as well - ie, if you have a tab, and have a container on the page of the tab - you could wait to load the container until it is requested by the user. You will be amazed at the speed that will produce.

>Wayne,
>
>Let me ask another question, and please excuse me if it's elementary. Currently, I just SEEK or GOTO a record in my table. All of the fields on my forms have the actual table as the datasource. Should I instead by using SQL Select statements and then deriving the fields from the cursor? This would be similar to my old Scatter/Gather days using memvars.
>
>Thanks.
>
>Fred