Return without GoSub error when opening form

[BetterBeef]

Hello,

I have been working on a specification database for a little bit now and it has worked for quite a long time. However, recently when I try to open the form after booting Access (2003 file using 2010 Access), I get the following error:

"The expression On Open you entered as the event property setting produced the following error: Return without GoSub."

Here is my code for On Open:
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
DoCmd.SetWarnings Off
'DoCmd.GoToControl "ProductCode"
Me.Filter = "Status = 'Active'"
Me.FilterOn = True

SetFilterStatus ("Active")
Me.ProductList.Requery
Me.ProductCodeLkup.Requery
'gstrResponse = "Active"
'Link = ''

End Sub

Here's the other interesting thing... When I go into the code and debug it, I try loading the form again, and it works without error! I am thoroughly confused as to what I need to do. Any thoughts?

Chris

 

[boblarson]

First, make a copy so if something goes wrong you can restore it.

Second, do a DECOMPILE and that should fix it.

See here for more about the Decompile and how to do it:
http://www.granite.ab.ca/access/decompile.htm

 

[BetterBeef]

Actually, I did something quite odd that fixed my problem. I simply went into the code itself and typed something, and then deleted the code, and it seemed to work. Any clue why that would have fixed it?

 

[boblarson]

Actually, I did something quite odd that fixed my problem. I simply went into the code itself and typed something, and then deleted the code, and it seemed to work. Any clue why that would have fixed it?

Yeah, the same thing that a decompile would accomplish (although a decompile would take care of situations not quite as light as yours). The problem is that occasionally the compiled code and the VBA editor get somewhat out of synch. What you ended up doing just got it back in synch when it recompiled when you ran it after saving. Sometimes that's all that is needed. Other times there may be situations where it is more in need of the full decompile process. But it is good you got it taken care of.

 

[BetterBeef]

Fantastic information to know! I appreciate your help!

 

[Andrey]

Yeah, the same thing that a decompile would accomplish (although a decompile would take care of situations not quite as light as yours)..

Dear Mr. Larson

Great thanks for your advice and great experiance from future - it's still actual in 2016
Hope you're well.

Regards