Add record in second subform

[joedalton101]

Ok so I have a simple form, with two subforms. Main form is artists, subform1 is albums and subform 2 is tracks.

Anyway I'v managed to make a button on the main form for adding records to subform1 with the following code:

Me!subform1.SetFocus
DoCmd.GoToRecord , , acNewRec

I'v tried to do the same thing with a different button to add records to subform2 but I'm having no luck. Why is this?

Me!subform2.SetFocus
DoCmd.GoToRecord , , acNewRec

I'm guessing it's something to do with subform2 (tracks) being based on subform1 (albums)??
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Also in subform1 I am unable to enter data but I am able to this in subform2. I am also able to edit current records in subform1. I have checked the following for subform1:

Enabled is Yes
Locked is No
Allow Edits is Yes
Data Entry is No

The subforms are based on tables

Thanks in advance

[whitbacon]

check out eh naming conventions

If you are on
Main form Sub 1
To refer to a form property, like RecordSource
On Mainform Me.RecordSource Me.Parent.RecordSource
On Sub 1 Me!Subform1.Form.RecordSource Me.RecordSource
On Sub 2 Me!Subform1.Form!Subform2.Form.
RecordSource Me!Subform2.Form.RecordSource
To refer to a control
On Mainform Me!ControlName Me.Parent!ControlName
On Sub 1 Me!Subform1.Form!ControlName Me!ControlName
On Sub 2 Me!Subform1.Form!Subform2.Form!
ControlName Me!Subform2.Form!ControlName
To refer to a control property, like Enabled
On Mainform Me!ControlName.Enabled Me.Parent!ControlName.Enabled
On Sub 1 Me!Subform1.Form!ControlName.Enabled Me!ControlName.Enabled
On Sub 2 Me!Subform1.Form!Subform2.Form!
ControlName.Enabled Me!Subform2.Form!ControlName.Enabled
To refer to a subform control property, like SourceObject
On Mainform N/A N/A
On Sub 1 Me!Subform1.SourceObject N/A
On Sub 2 Me!Subform1.Form!Subform2.SourceObject Me!Subform2.SourceObject

If you are on
Sub2 Not in these forms
To refer to a form property, like RecordSource
On Mainform Me.Parent.Parent.RecordSource Forms!Mainform.RecordSource
On Sub 1 Me.Parent.RecordSource Forms!Mainform!Subform1.Form.RecordSource
On Sub 2 Me.RecordSource Forms!Mainform!Subform1.Form!Subform2.
Form.RecordSource
To refer to a control
On Mainform Me.Parent.Parent!ControlName Forms!Mainform!ControlName
On Sub 1 Me.Parent!ControlName Forms!Mainform!Subform1.Form!ControlName
On Sub 2 Me!ControlName Forms!Mainform!Subform1.Form!Subform2.
Form!ControlName
To refer to a control property, like Enabled
On Mainform Me.Parent.Parent!ControlName.Enabled Forms!Mainform!ControlName.Enabled
On Sub 1 Me.Parent!ControlName.Enabled Forms!Mainform!Subform1.Form!ControlName.Enabled
On Sub 2 Me!ControlName.Enabled Forms!Mainform!Subform1.Form!Subform2.
Form!ControlName.Enabled
To refer to a subform control property, like SourceObject
On Mainform N/A N/A
On Sub 1 N/A Forms!Mainform!Subform1.SourceObject
On Sub 2 N/A Forms!Mainform!Subform1.Form!Subform2.
SourceObject