Next Button goes through Subform Records instead of Main Form

[prsdad0]

I have a Main Form [frmInfo] that is linked to [tblOfficerInfo], this form has a Subform; [frmEntries] that is linked to [tblLogEntries]. [frmEntries] is set as a Continuous Form so as to show the multiple records associated with the record being displayed on [frmInfo]. [tblOfficerInfo] is on the One side of a one to many relationship with [tblEntries].

My problem is when I click on the Next or Previous butttons (command buttons) that I have on [frmInfo] (the Main Form) it goes through all of the records in [frmEntries] (the SubForm) before going to the next record on [frmInfo], so if there are 40 records on [frmEntries] I have to click Next 40 times instead of 1 like I had hoped.

I have tried the GoToRecord Macro and the following three examples of code on the Command buttons. I know they are all pretty much the same but I have no idew what else to do.

DoCmd.GoToRecord , , acNext

and

DoCmd.RunCommand acCmdSelectRecord
DoCmd.GoToRecord , , acNext

and

DoCmd.SelectObject acForm, "frmInfo", False
DoCmd.RunCommand acCmdSelectRecord
DoCmd.GoToRecord acForm, "frmInfo", acNext

Also the Link Master Fields and Link Child Fields are set correctly.

Is it possible to accomplish what I want to do? If so I would greatly appreciate any help.