Get Next record from table with VBA in MS Access 2003

Reply

Join Date: Apr 2008
Posts: 5
Reputation: Scott Marchione is an unknown quantity at this point 
Solved Threads: 0
Scott Marchione Scott Marchione is offline Offline
Newbie Poster

Get Next record from table with VBA in MS Access 2003

 
0
  #1
Apr 21st, 2008
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...
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 1
Reputation: stevepep is an unknown quantity at this point 
Solved Threads: 0
stevepep stevepep is offline Offline
Newbie Poster

Re: Get Next record from table with VBA in MS Access 2003

 
0
  #2
Apr 23rd, 2009
I found this code snippet that works in the after update field:
DoCmd.RunCommand acCmdRecordsGoToNext
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC