Error while tabbing out - Column has Lost Focus Event property

[selvakumar.arc]

Hi,


I am working in MS Access 2010 and my OS is Windows 7. I am facing a weired issue in MS Access. In my Data Sheet view, I am tabbing from one column to another and I have written "Lost Focus" event for one of the column. When I tab out from the column (Lost Focus event column) I am getting error like...
The expression On Enter you entered as the event property setting produced the following error: Return without GoSub.
* expression may not result in the name of macro, the name of a user-defined function, or [Event Procedure]
* There may have been an error evaluating the function, event or macro.
And this error is happening to few users and it is working for me. I am not sure what is the issue behind this

Regards,
Selvakumar R

[ItsMe]

Sounds like one of the controls does not have a lost focus event handler but an Enter event handler. Check the names of the event handler by looking in the VBA module or the property sheet's Event Tab.

[Missinglinq]

You might want to simply eyeball the Form's Code Module; I've seen the error message

Return without GoSub

before when the developer had copied a procedure from one Form and pasted it into another Form, accidentally doing so in the middle of an existing procedure, something like this:

Private Sub AddClient_Click()

On Error GoTo Err_AddClient_Click
    
    DoCmd.GoToRecord , , acNewRec

Private Sub CancelNewRecord_Click()

On Error GoTo Err_CancelNewRecord_Click

 Me.Undo
 
Exit_CancelNewRecord_Click:
    Exit Sub

Err_CancelNewRecord_Click:
    MsgBox Err.Description
    Resume Exit_CancelNewRecord_Click

End Sub

Exit_AddClient_Click:
    Exit Sub

Err_AddClient_Click:
    MsgBox Err.Description
    Resume Exit_AddClient_Click
    
End Sub

Linq ;0)>

[ItsMe]

There you go. That rings a bell. Compile your code. Should error with ambiguous such and such if you have what Linq is describing.