David ---
"SELECT" does not open tables, USE opens table. SELECT just switches the current table to pointer to the workarea of whatever table you are selecting. I would think that the order they are being opened in any account would be irrelevent.
>> Do you have anything in the Activate of the first page -or- bound controls (via ControlSource) -or- do you have SELECT code in the Command button -or- do you have a DataEnvironment in this form with no tables -or- do you have DataSession for this form set to Private?
>
>John, i compaired the form to an older version that didn't have this problem and the only 'major' difference i see is the order the tables were opened by 'select'.
>in what order does VFP open tables with select and can it be changed?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05