SetFocus

[jminn0311]

How do you set the focus to a field in a subform in the after update event of a field on the mainform. It's got me bamboozeled.

THanks,
Jeff M.

 

[sfreeman]

Try this:

Private Sub MainField_AfterUpdate()
Forms![frmMain]![subMain].SetFocus
Forms![frmMain]![subMain]![subField].SetFocus
End Sub

 

[PHV]

If sfreeman's suggestion doesn't work, you may try something like this:
Private Sub MainField_AfterUpdate()
Forms![frmMain]![subMain].SetFocus
Forms![frmMain]![subMain].Form![subField].SetFocus
End Sub

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244