Hi Henry,
To find out which part of the form causes this problem do following
- open your form as a table USE frmUsers.scx NOUPDATE
- navigate to the record x
- The objname field should tell you what object it is. You can explore other fields of the record to gather more info.
>Thanks to Doug Hennig's SetDataDirectory() method, I have resolved my Local Vs Network problem with DBCs. In some forms, however, I seem to run into something that defies my understanding of how things run/fire.
>
>The error I get is: Error Loading file - record number x. frmUsers . ControlSource: Alias 'USERS'is not found.
>
>I have AutoOpenTables set to False. In my Load, I call SetDataDir() and it changes the Database property of all cursors to my network DBC. I get the above error even BEFORE I reach BeforeOpenTables() !! I'm trying to see what exactly it doesn't like but I just can't seem to STEP it earlier than the error.
>
>I have to add that the DE is a mixture of tables and local views.
>
>Doug's solution worked fine on rather complex custom forms. It failed on simpler (user maintenance) forms that inherit a lot from a class. Regardless of any inherited code, is there any way to STEP thru code before this dreaded error occurs ?
>
>Any ideas ?
>
>Thanks
>
>Henry
--sb--