Return without gosub access ошибка

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

Answers

• >    An Error occured while loading ‘Job01ResultsforStersub’.  Do you want to continue loading the project? <

  That was problably causing the error you had, and you have got solved now.

  Dont forget after done with coding to Compile your database again, see if there are any errors raised.

  Goto Visual Basic screen, Menu Debug, Compile … [your databasename].

  > By the way, when I open a module for code, all the modules open up behind it.  I believe there is a way to have only the single module open, right?  How is that done? <

  What do you mean like Cascade? All modules (code) are opened when going to your Visual Basic screen.

  You might press Restore or open one of the Modules Maximized.

  HTH,

  ---

  Daniel van den Berg | Washington, USA | «Anticipate the difficult by managing the easy»

  • Proposed as answer by

    Wednesday, June 15, 2011 1:02 PM

  • Marked as answer by
    Macy Dong
    Thursday, June 23, 2011 11:12 AM

Answers

• >    An Error occured while loading ‘Job01ResultsforStersub’.  Do you want to continue loading the project? <

  That was problably causing the error you had, and you have got solved now.

  Dont forget after done with coding to Compile your database again, see if there are any errors raised.

  Goto Visual Basic screen, Menu Debug, Compile … [your databasename].

  > By the way, when I open a module for code, all the modules open up behind it.  I believe there is a way to have only the single module open, right?  How is that done? <

  What do you mean like Cascade? All modules (code) are opened when going to your Visual Basic screen.

  You might press Restore or open one of the Modules Maximized.

  HTH,

  ---

  Daniel van den Berg | Washington, USA | «Anticipate the difficult by managing the easy»

  • Proposed as answer by

    Wednesday, June 15, 2011 1:02 PM

  • Marked as answer by
    Macy Dong
    Thursday, June 23, 2011 11:12 AM

Другие языки:

How to fix Error 3 (Return without GoSub) — A Return statement must have a corresponding GoSub statement.
Wie beheben Fehler 3 (Rückkehr ohne GoSub) — Eine Return-Anweisung muss eine entsprechende GoSub-Anweisung haben.
Come fissare Errore 3 (Ritorno senza GoSub) — Un’istruzione Return deve avere un’istruzione GoSub corrispondente.
Hoe maak je Fout 3 (Retour zonder GoSub) — Een Return-instructie moet een bijbehorende GoSub-instructie hebben.
Comment réparer Erreur 3 (Retour sans GoSub) — Une instruction Return doit avoir une instruction GoSub correspondante.
어떻게 고치는 지 오류 3 (GoSub 없이 돌아가기) — Return 문에는 해당 GoSub 문이 있어야 합니다.
Como corrigir o Erro 3 (Retornar sem GoSub) — Uma instrução Return deve ter uma instrução GoSub correspondente.
Hur man åtgärdar Fel 3 (Återvänd utan GoSub) — Ett Return -uttalande måste ha en motsvarande GoSub -sats.
Jak naprawić Błąd 3 (Zwrot bez GoSub) — Wyciąg zwrotny musi mieć odpowiadającą mu instrukcję GoSub.
Cómo arreglar Error 3 (Regresar sin GoSub) — Una declaración de devolución debe tener una declaración de GoSub correspondiente.

Об авторе: Фил Харт является участником сообщества Microsoft с 2010 года. С текущим количеством баллов более 100 000 он внес более 3000 ответов на форумах Microsoft Support и создал почти 200 новых справочных статей в Technet Wiki.

Are you trying to use Microsoft Access, but are you getting the error message ‘return without gosub’?

Tech Support 24/7

On this page, you will find more information about the most common causes and most relevant solutions for the Microsoft Access error ‘return without gosub’. Do you need help straight away? Visit our support page.

Let’s get started

It has never been easier to solve error «return without gosub».

View list of solutions
Contact an expert

Error information

How to solve Microsoft Access error return without gosub

We’ve created a list of solutions which you can follow if you want to solve this Microsoft Access problem yourself. Do you need more help? Visit our support page if you need professional support with Microsoft Access right away.

Tech Support 24/7

Have you found a solution yourself, but it is not in the list? Share your solution in the comments below.

Need more help?

Do you need more help?

Tech experts are ready to answer your questions.

Ask a question