Module level variable declaration.

[isladogs]

What is an IMO? Do you mean on load event?

I forgot the name of the term ie Label. My understanding is, labels can be directed to by meeting some criteria or on errors. But in case of the procedure in question, all of the code should be part of the label.

yctr = False  'OMIT THIS LINE IS SUPERFLUOUS
Exit_BeforeUpdate: yctr = False
 Exit Sub
Err_BeforeUpdate:
 MsgBox Err.Number & " " & Err.Description
 Resume Exit_BeforeUpdate
End Sub

And since these labels here are directed to only on error, (because there is no conditional criteria to goto a label), how come the resume key word will be executed/(Above code which falls under labels I suppose) if there were no error?

Answering the first part on behalf of Micron.
IMO = in my opinion

Looks like I need to explain how code flows in a procedure ...
Code is followed line by line in turn unless some event tells it to jump somewhere else.
So as already explained, when no error occurs it reaches Exit_BeforeUpdate, sets yptr false then exits the sub. It does NOT enter the Err_BeforeUpdate section.

If an error occurs, at that point it jumps to the Err_BeforeUpdate section (omitting anything in between), displays a message then moves back to the Exit_BeforeUpdate section and proceeds as in the previous sentence. Hope that is clear now

[Micron]

IMO in my opinion. IMHO in my honest opinion. AFAIK as far as I know... etc.

how come the resume key word will be executed/(Above code which falls under labels I suppose) if there were no error?

Because that's the way it is coded (or so it appears to me). If there is no Exit Sub/Exit Function line before the error handler, there is nothing to stop the error handling block from executing. The code flow is from Sub to End Sub unless something causes it to exit before, or it fails and stops because of an error.

[bubai]

Answering the first part on behalf of Micron.
IMO = in my opinion

Looks like I need to explain how code flows in a procedure ...
Code is followed line by line in turn unless some event tells it to jump somewhere else.
So as already explained, when no error occurs it reaches Exit_BeforeUpdate, sets yptr false then exits the sub. It does NOT enter the Err_BeforeUpdate section.

If an error occurs, at that point it jumps to the Err_BeforeUpdate section (omitting anything in between), displays a message then moves back to the Exit_BeforeUpdate section and proceeds as in the previous sentence. Hope that is clear now

Thanks mate!
Very much clear now.

[bubai]

Because that's the way it is coded (or so it appears to me). If there is no Exit Sub/Exit Function line before the error handler, there is nothing to stop the error handling block from executing. The code flow is from Sub to End Sub unless something causes it to exit before, or it fails and stops because of an error.

Cheers mate!
I thought Labels were not executed on their own. But it's clear now.