Refresh Method The Refresh method immediately updates the records in the
underlying record source for a specified form or datasheet to reflect changes
made to the data by you and other users in a multiuser environment.
tombrown1965 <[EMAIL PROTECTED]> wrote: 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
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us
---------------------------------
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail.
[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/
