Return without GoSub error

[Karen Patalano]

I am getting this new error when I open the drop down for names. Any suggestions. I checked on other forums and was unable to find the solution.
Thanks in advance...

 

[pbaldy]

What is the code behind that event? Alternately, go into the VBA editor and select Debug/Compile, which should bring you to the offending code.

 

[Karen Patalano]

Actually, it looks like it is a macro. Attached is the error that appears.

Thank you for your help.

 

[pbaldy]

I don't use macros; I'm not sure if you can use the Screen object within one. It doesn't look like that would run until a selection is made; are you getting the error when you drop down the combo?

 

[Karen Patalano]

I get the error after I select the name in the drop down.

 

[vbaInet]

Just wondering if this macro was created using the wizard? If it was, did you add or remove anything from it?

Maybe you should recreate it.

 

[Karen Patalano]

Just wondering if this macro was created using the wizard? If it was, did you add or remove anything from it?

Maybe you should recreate it.

The macro was probably created using the wizard. I don't believe that anything was added or removed. I can try to recreate the macro again.

 

[pbaldy]

I would first try just taking it out and seeing if you still get an error. That will narrow it down to that macro or point us elsewhere.

 

[vbaInet]

If after you've tried pbaldy's good suggestion and you're still having problems, then recreate the combo box and select the third option. I didn't mean recreate the macro.

...I can try to recreate the macro again.

 

[utzja1]

Having a similar problem with one of my forms, found this link that seems to explain the problem. I haven't had time to implement the suggestion but everyone who has reports success.

http://forums.techguy.org/business-applications/795546-solved-return-without-gosub.html