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...
 
Back
Top