David ---
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?
>> Something somewhere has to be opening the correspondence table or else it wouldn't show
>
>display status shows that each table is opened to a select area when i run the executible:
>
> 1 - correspondence
> 2 - assignments
> 3 - status
> 4 - rptlist
>
>so it must be trying to use 1 initially. if i set it to use 2 (assignments) in the command window, you can see the status bar change to 'Admin!Assignments' but as soon as i click one of the command buttons (like 'NEXT' for next record) it changes the select area. when i click on page2 of the form it works as it should.
------------------------------------------------
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