Navigating Forms and Selecting the Next Record

  • Thread starter Thread starter irritable_badger
  • Start date Start date
I

irritable_badger

Hello,

I'm using XP and Access 2007 SP1.

I have a form that has two combo boxes (cascading) and a 'save' button that
populates a field in a table when pressed. I can't figure out how to move to
the next record (based on the criteria defined in the combo boxes and their
queries) when the 'save' button is pressed.

What's the best way of doing this?

Thank You.
 
you need to add a bit of code to the save button

add

DoCmd.GoToRecord , , acNext

to add it right click on the save button in design view then click on
build event then add the above code after some code that may look like

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

hope this helps

Regards
Kelvan
 
Back
Top