Form hangs access displaying caculating when loading

[MikeT]

I have an app written in 2000 that loads a form just fine.

When I try to open it with Access 2007, the form hangs access displaying
"Calculating . . . " in the status bar causing a Not responding state.

The form has 4 tabs, 1 subform and several lookup fields in the primary tab.

I am using the switchboard to manage the app. If I launch access with
suppressing auto startup and launch the form from design mode I get the same
results. I have tried changing several properties on the form with no luck.
Any suggestions are appreciated.

Thanks!
Mike T.

 

[MikeT]

Linq Thanks for reply

Yes I did trust the location and subdirectories.

What's even stranger . . .

I have a second form that will lock up the same way when I insert a new row
(via add button) unless I first move to the end of the recordset.

Unfortunately, that trick isn't working on this form.