command buttons scroll subform not main form

  • Thread starter Thread starter SuzieDWong
  • Start date Start date
S

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
 
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
 
Back
Top