SetFocus to a field on an Access Navigation Form Subform

JamesJoey

Registered User.
Local time
Today, 13:38
Joined
Dec 6, 2010
Messages
642
I've searched but found nothing that works.
When I click a navigation button on an Access Navigation form I want the focus to go to a field on that page.

I've tried this but it doesn't work:
Code:
Forms!frmHome!frmDataSource.Form!MemoNotes.SetFocus

Any help will be appreciated,
James
 
I tried one example with my form names and I get an error:
Error 2465
Can't find field 'frmGroceryList' referred to in your expression.

Here's what I tried using my form names:

Code:
Forms!frmHome!frmGroceryList.Form.MemoNotes.SetFocus
 
Use the Load Event of your subform frmGroceryList

Private Sub Form_Load()
Me.MemoNotes.SetFocus
End Sub
 

Users who are viewing this thread

Back
Top Bottom