You can use Bookmark property.Open any VBA module and seek help on Bookmark. You can try the examples to see if you can acheive your goal.
HTH Liveson ----- Original Message ----- From: tombrown1965 To: [email protected] Sent: Monday, 04 September, 2006 12:00 PM Subject: [ms_access] Me.Requry form I have a form I use foe editing data in my tables. On certain field changes I secure those changes & flush out oldvalues by using Me.Requery This works fine, except that me.requery always seems to send me back to the first record & I then have to navigate back to the record I was at to continue editing. - Is there an alternative to Me.Requery (that will ensure oldvalue of controls is flushed)? - Or how can I mark the rcord I am on now so I can renavigate to it after the requery as follows (pseudoc codish): CurrentRecord = ThisOne Me.Requery GotoRecord (ThisOne) thanks [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
