Popup form behaviour - form not opening

[RexesOperator]

I am using Access 2003.

The db resides on another computer but is not yet on a network server. I have locked only the edited record, so I can add records from another computer while the other person is using it on theirs.

My main data entry form has three popups that appear when it is opened. Two of the three appear on my computer, but not the third one. Even when I click on the form from the db window, it does not open. It will open in design view. And I can view it in form view from the design view window.

When I open the form on the computer where the db resides all three appear normally.

Compact and repair did not fix the problem - nor did importing into a new db.

This is the code I am using from an OnClick event that calls the form frmADDNEWTRANSACTIONS. frmCOMPANYLIST is the one that doesn't open

DoCmd.OpenForm "frmADDNEWTRANSACTIONS", , , , acFormAdd
DoCmd.OpenForm "frmCOMPANYLIST", , , , acFormReadOnly
DoCmd.OpenForm "frmLASTQNUMBER", , , , acFormReadOnly
DoCmd.OpenForm "frmLASTTRXNNUMBER", , , , acFormReadOnly

 

[RexesOperator]

Does anyone have an idea? This affects only the one form.

 

[gemma-the-husky]

try removing the lock to see if that makes a difference - its not really necessary anyway

 

[RexesOperator]

I tried that as well (I discovered it wasn't necessary - as you say). No Joy. What I finally did was import a copy from a backup of the db I have on my computer into the one on the user's computer. That worked. Now everything is back to normal.

Another mystery of Access resolved. But why didn't it open on my computer? I doubt we shall ever know.