command buttons scroll subform not main form

[SuzieDWong]

Using Access 2007 main form shows client details and subform their charges.
Command buttons - next record - scrolls through each item on the charges
before moving to next client's record! Can't find how to link it to the
ClientID on the main form or any other solution!
Help! Suzie

 

[Graham Mandeno]

Hi Suzie

It's impossible to know and hard to guess, without knowing what code your
command button is executing.

Is the button on the main form or the subform? (It should be on the main
form)

It should be executing code something like this:

DoCmd.GoToRecord acForm, Me.Name, acNext

If that doesn't work, try this:

With Me.RecordsetClone
.Bookmark = Me.Bookmark
.MoveNext
If .EOF Then
MsgBox "No more records"
Else
Me.Bookmark = .Bookmark
End If
End With