Returning to Next Record

A

Ayelet

A bookmark prrobably would be he best way, except i'm not
sure how to use it either.
what i would do is this:
1. me.recordset.movenext (or me.movenext, i'm not sure)
2. lngRecordID = Me![IdField]
3. me.requery
4. Me.Recordset.FindFirst ("[ID] = " & lngRecordID)

I'm not positive this will work, but it's worth a try,
isn't it?
HTH,
Ayelet
 

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

Creating Labels Over 3-Up Image 2
Moving through records and EOF 1
Subform requery returns to first record 4
Using a Combo for Record Selection 2
Making form go blank when new Record is called 1
You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has a 1
Controlling row movement in a subform 2
From Command button, Find records beginning with ID# 2

Top