Error 2467 Help!

E

Eka1618

Hello,

I am receiving Error 2467 "object closed or doesn't exist"

I am trying to open a certain page in 2 tab controls (I have 14 total
pages). Every single page in my main form is causing this error to occur. To
be honest, a lot of objects in the main form cause this error when I try to
reference them.

For testing purposes’, I currently have the actual tab buttons showing. If I
click on the one that should be showing, It seems to go to the right IF
condition in my Load event.

I have a lot going on inside of the main form, there are around 20 sub forms
that are all doing different things when the Main Form loads, and I think it
may be why I am getting the error.

I turned off the Auto correct options as some other posts have suggested,
but I cannot seem to get past the error. Here are samples of code that I have
tried:

1.)
Private Sub Form_Load()

DoCmd.Close acForm, "frmQueueID", acSaveNo

If CurrentDb.Properties("TestType") = "IMPACT" Then

'THE LINES BELOW CAUSE THE ERROR

Me.pgImpact.Visible = True

Me.pgHandle.Visible = False
Me.pgOffset.Visible = False
Me.pgProof.Visible = False
Me.pgSecurity.Visible = False
Me.pgStatic.Visible = False
Me.pgTorque.Visible = False


Me.pgIResults.Visible = True

Me.pgHResults.Visible = False
Me.pgOResults.Visible = False
Me.pgPResults.Visible = False
Me.pgSecResults.Visible = False
Me.pgStResults.Visible = False
Me.pgTResults.Visible = False

End If

2.)
Private Sub Form_Load()

DoCmd.Close acForm, "frmQueueID", acSaveNo

Me.txtType.SetFocus 'THIS CAUSES THE ERROR

If Me.txtType.Text = "IMPACT" Then

Me.pgImpact.Visible = True

Me.pgHandle.Visible = False
Me.pgOffset.Visible = False
Me.pgProof.Visible = False
Me.pgSecurity.Visible = False
Me.pgStatic.Visible = False
Me.pgTorque.Visible = False


Me.pgIResults.Visible = True

Me.pgHResults.Visible = False
Me.pgOResults.Visible = False
Me.pgPResults.Visible = False
Me.pgSecResults.Visible = False
Me.pgStResults.Visible = False
Me.pgTResults.Visible = False

End If


I am just totally lost here. Any help would be appreciated!

Thank You!
~Erica~
 
J

Joao

Hello Eka, i am no guru but
In 1.) those objects are in frmQueueID? And at 2.) that form is where
txtType is located?
It seems you're closing the forms and trying to apply a setfocus... you
can't do that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top