John, guess I have something wrong - Getting an error. Not sure of the syntax. Here is what I have...
Forms!Switchboard!IncludeObject.Form.Recordset.FindFirst = Me.RID
Thanks in advance!
Mike
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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