GoToRecord moves in Sub-form not master

[DenS]

Hi,
On a Single Form with a sub-form I have set up the typical navigation buttons using the DoCmd.GoToRecord, ,acx where x = Next, Previous.

These navigate through the sub form records. I only want to navigate through the master records.

I know there is probably more information required to answer this but thought i'd get the conversation started.

Extensive searching did not turn up the answer. There are many articles on moving through the sub-fom but nothing about just the master.

Thanks for reading this...

 

[smig]

Did you put the button in the top or sub form ?
Move the focus to the top form before trying to go to records.

 

[DenS]

Thanks for the reply.
The buttons are in the top form. Tried the detail and header sections with the same result.
SetFocus to any of the top forms fields does highlight that field but does not change the action of walking through each of the sub-form records then moving the top form.

Den

 

[JHB]

Did you put in the form name in the arguments for the DoCmd.GoToRecord?
Here is a link how to use DoCmd.GoToRecord.
http://msdn.microsoft.com/en-us/library/office/ff194117(v=office.15).aspx

 

[DenS]

I got it.... Seems the issue was in my query for the main form that included the link to the sub-form's table. Thought i removed that way back when ...

Thanks for the help... superb site.
Den