Compile error: label not defined

B

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!
 
A

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.
 
B

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 -
Click to expand...

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

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

SASKOPEJCINOSKI

Bellyjeans said:
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!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form_Close: Recordset Out Of Scope? 4
Modify Allen Browne Calendar - Automatically Enter Day For Chosen 18
Modify Allen Browne Calendar 2
Help --> Compile Error - User defined type not defined 2
Label Not Defined 3
What does On Error Goto 0 do? 4
What's causing error 2465? 4
Compile error- Invalid use of property 2

Top