Help! "On Close" command not functioning!

[shieriel]

I am working on my database and they are working fine until all of a sudden my "on close" function on my form doesnt work! I got an error as attached here. Please help what are the possible error on my db.

 

[SOS]

What do you have in your On Close event and did you put it in the VBA window and NOT in the event properties dialog?

 

[shieriel]

What do you have in your On Close event and did you put it in the VBA window and NOT in the event properties dialog?

This is my code under "On Close" event in the vba window and it is functioning ok until just now when i close the form that error appears.

Private Sub Form_Close()
DoCmd.OpenForm "Switchboard1"
End Sub

 

[SOS]

Can you post a screenshot of your form, the one closing, (with the properties dialog showing on the events tab).

 

[shieriel]

Can you post a screenshot of your form, the one closing, (with the properties dialog showing on the events tab).

Please see attached. the one is when i close the form, and the other one is showing the vb code window...

 

[SOS]

Nope, not quite what I wanted to see. I wanted to see the PROPERTIES DIALOG EVENT tab with the entries there (if any) - like this:

 

[shieriel]

Nope, not quite what I wanted to see. I wanted to see the PROPERTIES DIALOG EVENT tab with the entries there (if any) - like this:

Ok sorry. Please see attached...

 

[shieriel]

any help for this?

 

[SOS]

Yeah, because everything looks the way it should, try importing everything (import, not copy and paste) into a new, blank database shell. I think some corruption is creeping in and doing the import should fix that.

 

[stopher]

Try deleting the offending code then re-implementing it.

Also, try compiling.

Chris

 

[shieriel]

Thanks Stopher and SOS! Everything looks ok now after importing and then re-applying the codes again.
Thanks so much...