ACCESS FEED: Re: [MS_AccessPros] Form Requery

Selasa, 31 Juli 2012

Re: [MS_AccessPros] Form Requery

Nevermind John, I got it...

Forms!Switchboard!IncludeObject.Form.Recordset.FindFirst "LOOKUP_ID = " & Me.RID

Thanks in advance!
Mike

--- In MS_Access_Professionals@yahoogroups.com, mithomas48 <no_reply@...> wrote:
>
> 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
> >
>