Mike-
Why are you doing a Requery? The update should show in the original form -
perhaps after a second or two. A Refresh should fix that.
But if you insist on doing a Requery (perhaps the user added a record), save the
Primary Key of the record saved, then after the Requery grab the Recordset of
the subform and do a FindFirst on the PKey value. That should position the form
back to the changed record.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mithomas48
Sent: Tuesday, July 31, 2012 7:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Form Requery
When a user scrolls down a continuous form, clicks on a record to edit, a popup
form comes up. After making a change and saving the popup form requeries the
continueous form. When this happens the continueous form goes back to the top
record. Is there a way to keep this from happening but still show the update?
Code:
Forms!Switchboard!IncludeObject.Form.Requery
Thanks in advance!
Mike
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar