Moving to Field in Tabbed Form

Novice1

Registered User.
Local time
Yesterday, 16:26
Joined
Mar 9, 2004
Messages
385
I have a tabbed form. I have an AfterUpdate command to check to see if SubjectEmail is blank on the first tab (Individual). I can move to the tab but I cannot move to the SubjectEmail field. I get an error, that the field doesn't exist in the record. I'm apparently referring to the field incorrectly. I've searched but cannot find the answer. Any help would be appreciated.


If IsNull([SubjectEMail]) Then
MsgBox "Sponsor's e-mail field is blank. Cannot send e-mail at this time", vbOKOnly, "Missing E-mail"
Me.[Individual].SetFocus
DoCmd.GoToControl "SubjectEmail"

Else
End If
 
I would simply to to the control, with:

Me.TextboxName.SetFocus

You shouldn't have to go to the tab first. Regarding your error, you want the name of the textbox there, not the underlying field.
 

Users who are viewing this thread

Back
Top Bottom