Share via

Suddenly receiving "Return without GoSub" error when opening default form

Anonymous
2014-10-31T13:58:40+00:00

We have been using the Asset Tracker database template downloaded from Microsoft without issue for a few weeks. This morning we started receiving a message box displaying "Return without GoSub" when the default form opens. Clicking OK closes the message and the form opens but then displays the following:

The #Name? is a link that says either "New" or "Open" that then opens a form displaying the details of the current asset . I am not aware of any changes being made to the form or any of the code behind the form, and it worked fine yesterday. When we click the link now, we get the "Return without GoSub" message box again, and clicking OK then displays the following:

I've looked in the embedded Macro, which we have NOT modified, and cannot find "Return" anywhere. In addition, there is no "Return" in the two VBA modules that are in the database. I've done basic VBA in the past, but nothing with the new embedded macros, so I am really at a loss here as to how to fix this. Any ideas/suggestions? We were hoping to start performing a physical inventory of PCs, etc., on Monday, so of course this pops up today!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Anonymous
    2014-10-31T14:11:43+00:00

    Usually when that error pops up it is because a code page has become corrupt. Run the Compact and Repair on the database. If that doesn't fix it try decompiling it. Instructions are here at FMS

    10+ people found this answer helpful.
    0 comments No comments

Answer accepted by question author

  1. Anonymous
    2014-10-31T14:41:18+00:00

    Bill, to paraphrase your signature line: "That did it". Thanks for your quick response. You saved the day.

    Thanks for the kind words. I'm glad it was what you needed.

    3 people found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2014-10-31T14:30:42+00:00

    Bill, to paraphrase your signature line: "That did it". Thanks for your quick response. You saved the day.

    0 comments No comments