Значение свойства linkmasterfields вызывает ошибку return without gosub

Answers

• Hi NoviceVBAuser1775,

  «Return without GoSub» means that
  you have a Return statement that can’t be matched with a GoSub statement.
  
  Make sure your GoSub statement wasn’t inadvertently deleted.

  You can get more detail about this error from link below:
  Return without GoSub (Error 3)

  This error is runtime error and it is a code issue. It means that complie will not address this issue. I suggest that you check code to see whether the code is correctly. For example, the code below will throw this error if we commnet the code «Exit
  Sub»:

  Sub TestError()
  
  Debug.Print "begin.."
  GoSub label1
  
  Exit Sub 'comment this line will cause this issue
  
  label1:
  Debug.Print "1"
  label2:
  Debug.Print "2"
  Return
  End Sub

  If you still have problem fixing this issue, I suggest that you share with us the code snippet you are developing with.

  Hope it is helpful.

  Regards & Fei

  ---

  We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
  
  Click
  HERE to participate the survey.

  • Edited by

    Friday, April 10, 2015 6:45 AM

  • Marked as answer by
    Fei XueMicrosoft employee
    Wednesday, April 15, 2015 12:23 PM

SO something strange happened, I was cleaning up my database and deleted a button that honestly just closed the current form and opened a different datasheet. now whenever i try to select a field or do anything I get things like The LinkMasterFields property setting has produced this error: ‘Return without GoSub’ …i Dont really understand how this could all of a sudden happen

thanks for any input it would be greatly appreciated

• ms-access-2007

asked Jan 2, 2014 at 15:01

1 Answer

Problem Solved, Allthough i did delete the button the error was caused when i didnt delete the click event associated with the button. It is strange i think because i have most certainly deleted buttons before and didnt need to delete there click event scripts and everything still worked fine.