SetFocus to a field on an Access Navigation Form Subform (1 Viewer)

J

JamesJoey

Registered User.

Local time

Today, 10:23

Joined

Dec 6, 2010

Messages

608

• Sep 3, 2015

• #1

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:Copy to clipboard

Forms!frmHome!frmDataSource.Form!MemoNotes.SetFocus

Any help will be appreciated,
James

 

apr pillai

AWF VIP

Local time

Today, 19:53

Joined

Jan 20, 2005

Messages

735

• Sep 4, 2015

• #2

Check this out:Setting Focus on Field inside Sub-Form

 

Last edited: May 8, 2018

J

JamesJoey

Registered User.

Local time

Today, 10:23

Joined

Dec 6, 2010

Messages

608

• Sep 4, 2015

• #3

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:Copy to clipboard

Forms!frmHome!frmGroceryList.Form.MemoNotes.SetFocus

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 22:23

Joined

May 7, 2009

Messages

19,230

• Sep 5, 2015

• #4

Use the Load Event of your subform frmGroceryList

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