Programming Forums - View Single Post

Rory · Apr 12th, 2005, 4:09 AM

Right, the simplest way to interact with the form in VBA is to manipulate the DoCmd object exposed by the navigation controls, required constants can be found through the object inspector or help. To actually add code you'll have to tie it to a VB event handler (right click the object -> build event).
For instance the following code will save the current record:

(Toggle Plain Text)

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord

So to go to the next record would be:

(Toggle Plain Text)

DoCmd.GoToRecord , , acNext

and so on. Hope this is helpful.

Apr 12th, 2005, 4:09 AM	#4
Rory Expert Programmer Join Date: Jan 2005 Location: London Posts: 542 Rep Power: 4	Right, the simplest way to interact with the form in VBA is to manipulate the DoCmd object exposed by the navigation controls, required constants can be found through the object inspector or help. To actually add code you'll have to tie it to a VB event handler (right click the object -> build event). For instance the following code will save the current record: (Toggle Plain Text) DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord So to go to the next record would be: (Toggle Plain Text) DoCmd.GoToRecord , , acNext DoCmd.GoToRecord , , acNext and so on. Hope this is helpful.