mloucel
Member
- Local time
- Today, 15:13
- Joined
- Aug 5, 2020
- Messages
- 352
This code works perfectly, but I tried to simplify and somehow I got lost..
I tried to simplify the code without the use of so many [ ] but I am getting lost
The Commented Line:
'Me!PatientAdmitanceF!PatientNotesSF.Form!Pnote.SetFocus
was my futile effort, is there a better way?
This is a FORM that contains a subform, once the fields on the form are verified to be correct, I make the SubForm visible.
Now I want to SetFocus to the field called Pnote
the code works but I would really want to simplify it as much as possible [ I AM LEARNING ]
does anyone have any Ideas..
I have checked this:
No luck..
MVPS_Website_Link
Anyone with a better Idea???
I tried to simplify the code without the use of so many [ ] but I am getting lost
The Commented Line:
'Me!PatientAdmitanceF!PatientNotesSF.Form!Pnote.SetFocus
was my futile effort, is there a better way?
This is a FORM that contains a subform, once the fields on the form are verified to be correct, I make the SubForm visible.
Now I want to SetFocus to the field called Pnote
the code works but I would really want to simplify it as much as possible [ I AM LEARNING ]
does anyone have any Ideas..
I have checked this:
No luck..
MVPS_Website_Link
Anyone with a better Idea???
Code:
' Set the focus to the Note
[Forms]![PatientAdmitanceF].[PatientNotesSF].SetFocus
[Forms]![PatientAdmitanceF].[PatientNotesSF].[Form].[Pnote].SetFocus
'Me!PatientAdmitanceF!PatientNotesSF.Form!Pnote.SetFocus