Setting and Keeping Focus Issue (on the edge here!)

[smbarney]

I have a subform (sfmIncidentDetailsUpdates) with a field (TextDetails) with the following code in the on exit event:

Private Sub TextDetails_Exit(Cancel As Integer)
Dim strSpell
strSpell = Forms![IncidentForm]![sfmIncidentDetailsUpdates].Form![TextDetails]
If IsNull(Len(strSpell)) Or Len(strSpell) = 0 Then
Exit Sub
End If
With Forms![IncidentForm]![sfmIncidentDetailsUpdates].Form![TextDetails]
.SetFocus
.SelStart = 0
.SelLength = Len(strSpell)
End With
DoCmd.SetWarnings Fals
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True


Form.SetFocus
End Sub

This works in the sense that it checks the spelling this field only on exit. However, when you move between records on the main form it checks all of the fields on the subform, not just this one.

Have I referenced the field incorrectly? Is there a way to tell it to ignore the other fields on the subform?

Interestingly, I use this same code on the main form and it works without problem.

Sorry that this is a repost. However, I better defined the problem. Thanks

 

[KenHigg]

I've never used the spell check stuff but I would suspect you need to trigger it on a control event and not the form / subform event?

 

[smbarney]

It is....It triggers from on exit event on the [TextDetails] field.

 

[KenHigg]

Oh - Sorry. Maybe try it in the after update?

 

[smbarney]

No good. By running the code in the after update event, causes an error. Any other suggestions? This seems so easy and it is so not. Why?