Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Refer to Next/Prev Record

Status
Not open for further replies.
orna

orna

Programmer
Apr 2, 2002
314
0
0
IL
Hi,

Is it possible to refer to or update the next or prev
record when I'm looping?

Thanks
 
Sort by date Sort by votes
I think you would need to .movenext, load the value(s) in a variable and then moveprevious, and then do your update...

HTH
 
Upvote 0 Downvote
Thank you for replying.
I hoped there is a better way to do it.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
170
Kennelbloke
Kennelbloke
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
129
dhookom
dhookom
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
135
Moss100
Moss100
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
130
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
88
Viswa.R
Viswa.R

Part and Inventory Search

Sponsor

Back
Top