>Hopefully someone can give me clear direction on when databases load, how the load order is determined for the individual tables.
>
>If my database container holds 6 separate tables, how do I determine the order they loaded to know which one is a,b,c,d,e,f when I want to reference them under my control source without having to type the entire names.
>
>Thanks
>
>Todd

Todd, opening the database does not mean that the tables are open. When you open them they are opened in the next available area unless you explicitly issue SELECT 1 (or 2, 3, etc) I personally never reference the tables as a, b, c, etc. It is much more convenient to use alias names for the ControlSources.

Nick