Compile error: label not defined

[Bellyjeans]

Hi everybody,

I have two forms; I'm trying to requery a couple of fields on the
first form when I close out of the second form. I have the following
code on the OnClose event of the second form:

Private Sub Form_Close()
On Error GoTo Err_Handler

Forms!frmReferralTracking!RefDoctorID.Requery
Forms!frmReferralTracking!refDoctorLast.Requery

End Sub

Err_Handler_Exit:
Exit Sub

Err_Handler:
MsgBox Err.Number & " - " & Err.Description & " - Form_Close()"
Resume Err_Handler_Exit
End Sub

This is giving me a "Compile error: Label not defined". I'm not sure
what's causing this. Is it a problem with the error trapping?

Thanks in advance!

 

[Allen Browne]

Remove the:
End Sub
from the middle of the sub.

That's not the end, and consequently Access could not find the Err_Handler
label within the sub.

 

[Bellyjeans]

Remove the:
    End Sub
from the middle of the sub.

That's not the end, and consequently Access could not find the Err_Handler
label within the sub.

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.














- Show quoted text -

Ah... it's always the little errors that lead to problems, eh?

Worked like a charm. Thanks Allen for your help. Much appreciated!

 

[SASKOPEJCINOSKI]

Hi everybody,

I have two forms; I'm trying to requery a couple of fields on the
first form when I close out of the second form. I have the following
code on the OnClose event of the second form:

Private Sub Form_Close()
On Error GoTo Err_Handler

Forms!frmReferralTracking!RefDoctorID.Requery
Forms!frmReferralTracking!refDoctorLast.Requery

End Sub

Err_Handler_Exit:
Exit Sub

Err_Handler:
MsgBox Err.Number & " - " & Err.Description & " - Form_Close()"
Resume Err_Handler_Exit
End Sub

This is giving me a "Compile error: Label not defined". I'm not sure
what's causing this. Is it a problem with the error trapping?

Thanks in advance!

 

[SASKOPEJCINOSKI]

 

[viktor chuzhakin]