Go to previous record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which is open. I have set up a command button to perform a series of actions. I would like this command button to also go to the previous record on the form. Any advice? I think I have to use the DoCmd.GoToRecord, but I am unsure how to use this. I am new to access and Visual basic.

The form I have is called fmservices.

Thanks

Ronnie
 
Try adding the following line:

DoCmd.GoToRecord acActiveDataObject, , acPrevious

HTH

Byron
-----Original Message-----
I have a form which is open. I have set up a command
Click to expand...
button to perform a series of actions. I would like this
command button to also go to the previous record on the
form. Any advice? I think I have to use the
DoCmd.GoToRecord, but I am unsure how to use this. I am
new to access and Visual basic.
 
Thanks Bryon

Worked a treat

Byron said:
Try adding the following line:

DoCmd.GoToRecord acActiveDataObject, , acPrevious

HTH

Byron
button to perform a series of actions. I would like this
command button to also go to the previous record on the
form. Any advice? I think I have to use the
DoCmd.GoToRecord, but I am unsure how to use this. I am
new to access and Visual basic.
Click to expand...
 
You must log in or register to reply here.

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

Going to first record 0
Access Automatically Send a notification email once a record is added 0
Go to Current Record on load 4
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Go to last record (Access 2003) 3
DoCmd.GoToRecord - First record 2
GoToRecord on Split Form with Hidden Fields 0
show Last 15 records on sub form 1

Back
Top