The problem comes when trying to set the focus back to the main form from a subform. I have used the .GoToControl action after the lost focus event to have the person go directly into the subform. exiting the subform I tried to do the same thing,but I keep getting an error saying the field is not in the record.
The FAQ section dealing with syntax was a little confusing to me.
Attached is the procedure I used to get to the subform.
Private Sub ysnWorkNewConstruction_LostFocus()
On Error GoTo ysnWorkNewConstruction_Err:
DoCmd.GoToControl "fsubSpecificationFrequencyfrmChangeContactInformation"
DoCmd.GoToControl "ysnSpecifyBasinGrate"
ysnWorkNewConstruction_Exit:
Exit Sub
ysnWorkNewConstruction_Err:
MsgBox Error$
Resume ysnWorkNewConstruction_Exit
End Sub
I would appreciate any help. thanks
The FAQ section dealing with syntax was a little confusing to me.
Attached is the procedure I used to get to the subform.
Private Sub ysnWorkNewConstruction_LostFocus()
On Error GoTo ysnWorkNewConstruction_Err:
DoCmd.GoToControl "fsubSpecificationFrequencyfrmChangeContactInformation"
DoCmd.GoToControl "ysnSpecifyBasinGrate"
ysnWorkNewConstruction_Exit:
Exit Sub
ysnWorkNewConstruction_Err:
MsgBox Error$
Resume ysnWorkNewConstruction_Exit
End Sub
I would appreciate any help. thanks