Refreshing a form while returning to the next record 1

[CSADataCruncher]

I have a form that shows job entry data for last week's work only. I've recently added a command button that runs an "update query" on the table used in the form but, in order to see the new data created by the update query, I must requery or refresh the form. My problem is, when I refresh the form, it always returns to the first record.

How can I refresh the form and either return to the current or next record in the form?

Thank you,
Peggy Neubert
CSA

 

[MajP]

You get the primary key from your current record, do a requery, then return to that record

dim myPK as long
myPk = me.somefield
'do your update query here
'Do a find first
me.recordset.findfirst "someField = " & myPK

 

[CSADataCruncher]

Thank you so much! This works!

 

[dhookom]

CSADataCruncher,
Please use the "Great post? Star it!" link to show your thanks and mark the thread as answered.

Duane
Hook'D on Access
MS Access MVP