Calculating ....... In Bottom Left Corner When opening form from another form, Access 2010

[DevelopV]

I have a form that opens just fine.
If I open it using a command button on another form it also opens fine.
However if I open it using a command button on a 2nd form it also opens fine BUT, the word Calculating...... appears on the 2nd form's bottom left corner and Access hangs.

There are no errors if I step through the code

I have tried adding Do Events after DoCmd.OpenForm "frmOther" but with no success

What causes this and how do I trouble shoot it?

Many thanks

 

[dhookom]

Provide all of your relevant code.

Duane
Hook'D on Access
MS Access MVP