I have a main form called: Patient Information
On this form I have a subform called: [name_Age Qry_form]
and a field in this form is: [Age]
Also on this form is a Tab Control called: [TabCtl38]
The First tab is called: [Contact Info]
and on this tab is a subform called: [Contact Info_tab]
and on this subform is a field called: [DOB]
If someone clicks on the age to try and change it, i have a message box that pops up telling them to edit the DOB because the age will automatically populate.
Now I'm trying to set the focus to the DOB field so they can enter the date. How do i do this?
This is what I tried:
Expand|Select|Wrap|Line Numbers
- Private Sub Age_GotFocus()
- Forms![Contact Info_tab].Form!DOB.SetFocus
- MsgBox "To edit their age, edit their DOB under the Contact Info tab. Their age will automatically update once their DOB is entered or adjusted.", vbInformation, "Age updates automatically"
- End Sub