Requery then go back to same record.

[Bill]

Hi All,

I have a horrible feeling that I am asking too much here - at least with my
current skills!!!!

By design when I carry out a certain action on a form the underlying data is
required by the record goes back to the first record in the dataset. What do
I need to do so that the record goes back to the record that I was in?

Regards.
Bill.

 

[[MVP] S.Clark]

Yes, this is a tricky one. In VBA code, you could create a 'recordsetclone'
of the forms data, 'find' the record, then set the 'bookmark' property.
Lookup in the help for either or all of these keywords.


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[Bill]

Ok thanks Steve.

Yes, this is a tricky one. In VBA code, you could create a 'recordsetclone'
of the forms data, 'find' the record, then set the 'bookmark' property.
Lookup in the help for either or all of these keywords.


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[John Spencer]

When you requery, then that is what happens.

If you are causing the requery through code, you need to store the primary
key of the current record in a variable, do the requery, and then find the
original record and move to it in code. Something like the following AIR
CODE (untested) snippet.

Dim vPK as Long 'Assumption that your primary key is a number field

vPK = Me.txtBoxWithPrimaryKeyValue
Me.Requery

With Me.RecordsetClone
.FindFirst "PrimaryKeyField = " & vPK
If .NoMatch = False then
Me.Bookmark = .Bookmark
End IF
End With