Record navigation with multiple subforms

[Thenolos]

Howdy,

I'm working on a new database that utilizes a good deal of subforms. Structure is like this Main Form / Subform / Sub-Subform (or whatever you call it). I have record navigation command buttons on the Subform that I would like to control the records on the Sub-Subform. The code I am using behind the command button is:

Forms![frmMain]![subMain].Form![minTodo].SetFocus
DoCmd.GoToRecord , , acLast

frmMain is the Main form
subMain is the control name for the subforom
minTodo is the control name for the sub-subform

No errors occur, but nothing happens. Any ideas guys?

 

[Thenolos]

I found that

Me![minTodo].SetFocus
DoCmd.GoToRecord , , acLast (or acNext etc...))

Works as long as I am using [subMain] as the main form as apposed to the first subform.

Still does nothing when [minTodo] is the secondary subform.

 

[Thenolos]

Nevermind, got help on another forum.