Code for Button on MainForm won't function correctly on for the subform

[breakingme10]

Ok I've searched and nothing seems to tackle my exact problem, and i've tried modifying codes i've found to fix this problem, but nothing.



I have a navigation form with subforms.



The button i'm working code on is the "New Record" button. It works but will not let me set the focus to the field in the subform I want it to go to after it is clicked. in the second image, on the subform itself i have a "Save-New" button that will work and go to the control i want it to. But i'd like to get rid of that button and just use the "New Record" button since it will be at the top of each subform.

right now the code is

Private Sub cmdNewRecord_Click()
Me.NavigationSubform.Form.Recordset.AddNew
End Sub

I've tried adding a set focus and can't get it to work, i would need it to be with an iif because depending on which subform it is it needs to shift focus to a different control.

Can anyone help me with this?

[ItsMe]

With navigation forms you are limited to the Navigation Button's properties. Getting VBA to fire with an on click of the navigation form's buttons is difficult if not impossible. Also, your windows theme appears pink on my monitor.

[breakingme10]

my windows theme is pink.
they aren't navigation buttons they are command buttons just put onto the navigation form between the navigation buttons and the subform control

[ItsMe]

It looks as though you have two layers. So I would guess you have two navigation control names. I do not work with Nav Controls because they have too many nuances and not enough advantages considering my needs.

I was able to change a value in an unbound control but not able to set focus.
Forms!frmNavForm1.NavigationSubform.Form.txtSample .Value = 12
Forms!frmNavForm1.NavigationSubform.Form.txtSample .SetFocus

This has always been my experience. Some things work and everything is fine and then something that would seem simple is a huge hurdle.

[breakingme10]

I have a two lay nav control NavControl0 and then 5, What would you suggest to use instead of a navigation?

[breakingme10]

The button's "name" when accessed from loaded forms in expression builder is Forms![MainForm]![cmdNewRecord] if that helps at all

[ItsMe]

The issue I see with the Nav Control is that it is difficult to edit properties of objects and invoke methods. Sure, they give you events like On Click, but you can't always talk to the fields/controls you want to.

As for the fully qualified name of a second layer, maybe
Forms![MainForm].NavigationSubform.NavigationSubform2.Form.txtSamp le.Value

The alternative to the Navigation Control is the Tab Control. If feel you need to be building Web Forms in order to exploit the Nav Control.

[breakingme10]

I'm hoping to one day turn this into an actual stand alone program, or access program that I can put on any computer at work.

[ItsMe]

I'm hoping to one day turn this into an actual stand alone program, or access program that I can put on any computer at work.

I do this sort of thing all of the time. The only difference is I do not use the Navigation Control. If you are building desktop apps, apps that are not used over the internet or with SharePoint, then you may not need the Navigation Control.