ACCESS FEED: RE: [MS_AccessPros] Form Requery

Selasa, 31 Juli 2012

RE: [MS_AccessPros] Form Requery

Mike-

It's great when you solve your own problem!

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:53 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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
> >
>

------------------------------------

Yahoo! Groups Links