Hello all,
I was wondering if someone knew the syntax for getting the next record in a table for Access?
I want to write an event procedure that will allow the users to get the next record, either up or down. I know where to put the code ( I think I'm just going to use the mouse wheel, but if they don't like it then I'm going to use the Keyboard up and Keyboard down properties of the form). I'm used to writing in Lotus Script, and there is a method called GetNextDocument....but I can't seem to find the VB equalivalent...

I found this code snippet that works in the after update field:
DoCmd.RunCommand acCmdRecordsGoToNext