docmd.openform Invalid database object reference

[snoopy2003]

Hello,

I have a problem and I hope you will agree to help me.

After modifying database links (front end to new backend),
one form does not open and generated reference error 3276.

I open the form by clicking on tree control node.
but It does not open directly from DB window.

but, If I compact & Repair the file it opens correctly.



What should I do in order to ovoid this error ?

Thank you for your help

Private Sub menuTree_Click()
       Dim strcrit As String
       stricrit = menuTree.SelectedItem.Key
       DoCmd.Close
       DoCmd.OpenForm stricrit
End Sub

[HiTechCoach]

Try:

Private Sub menuTree_Click()
      Dim strcrit As String
      stricrit = menuTree.SelectedItem.Key
      DoCmd.OpenForm stricrit

      Docmd.Close acForm,Me.Name

End Sub

[snoopy2003]

Hello,

Thank you for your help. I changed the code but it did not solve the problem.

If I try to open the form directly from the DB window I get:"
Invalid Database object reference".

If I try to open the form in design view and then and then in form view it works.

After Compact and repair it works with no error in all cases.

What am I doing wrong ?

Thank you for your help

[HiTechCoach]

Some other things to try:

1) De-compile the VBA using /decompile

2) Export the objects having issues. Delete them. Restore them. See: Backing up and Restoring Objects

3) Create a new blank database and import all the object.


Could be an Access 2010 issue. I am waiting on SP1 before I consider using it in production.

[snoopy2003]

Hello,

Thank you for your help. Backup & restore solved my problem.

Thank you for your support, It is the main form of my
application and I could not find a solution.

[HiTechCoach]

You're welcome.

Glad I could assist.