command buttons scroll subform not main form

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering main form via selecting record in subform 7
Unremovable horizontal scroll bar on subform 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Scroll records in main form - ignore linked subform records 3
Record navigation buttons on mainform and subform 3
Requery main form after subform update and not lose place in main form. 3
showing a subform based on the main form 5
subform based on external SQL won't requery 1

Top