Controlling subform record from mainform

P

Paul Byford

I would like to add record navigation buttons to my
mainform that will show next or previous record on the
attached subform. Any ideas? Cheers
 
B

Bill

Try this:
DoCmd.GoToRecord , Me.SubFormName.Form.Name, acNext
DoCmd.GoToRecord , Me.SubFormName.Form.Name, acPrevious
DoCmd.GoToRecord , Me.SubFormName.Form.Name, acFirst
DoCmd.GoToRecord , Me.SubFormName.Form.Name, acLast
DoCmd.GoToRecord , Me.SubFormName.Form.Name, acNewRec
replace SubformName with the name of the SubForm Control and not the name of
the subform it holds.
HTH
Bill
 

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

Record navigation buttons on mainform and subform 3
insert sql form-subform problem 0
subform total to mainform 4
Split form 0
How do i search a subform from the Mainform? 6
changing mainform record from subform 3
Please Help!!! Macro required to select new record in Subform 0
printing multiple part labels 1

Top