Re: Diff between refresh & requery

From: '69 Camaro (Black_hole.To.69Camaro_at_Spameater.org)
Date: 08/09/04 

Date: Sun, 8 Aug 2004 19:21:37 -0700

Hi, Andrew.

>From Access Help:

"The Refresh method shows only changes made to records in the current set.
Since the Refresh method doesn't actually requery the database, the current
set won't include records that have been added or exclude records that have
been deleted since the database was last requeried. Nor will it exclude
records that no longer satisfy the criteria of the query or filter. To
requery the database, use the Requery method. When the record source for a
form is requeried, the current set of records will accurately reflect all
data in the record source."

I might add that "Refresh" won't show changes that other users have made in
the database since your Form's RecordSet was last opened, but "Requery"
will. Essentially, "Refresh" shows your own changes to the Form's
RecordSet, but "Requery" shows everybody's changes to this RecordSet.

Normally, when a Form is requeried, the current record will point to the
first record in the RecordSet. If you receive the "No current record" error
message after trying to access a bound field immediately after the "Requery"
operation, then there are no records that met the criteria for the Form's
record source, so the database returned zero records when requeried.

Your other Forms may not need to be changed from "Requery" to "Refresh." It
depends upon whether or not these other Forms need to have the latest
RecordSet from the database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

"Andrew Backer" <abacker_remove_Uspamerz@comcast.dot.net> wrote in message
news:ugldh0hurti2923pma0drvikqd3q0m1aem@4ax.com...
> I have a question about the difference between refresh & requery :
> What is it?
>
> I have a form that uses me.Requery after performing a certain action.
> I noticed that after doing this I could not access fields in VB
> (Me.Recordset!FieldName, or other ways) without getting a 'no current
> record' error. The thing that gets me is that all normal editing
> still worked, the form looks ok, etc.
>
> I changed to Me.Refresh and everything is ok.
>
> When should I use one and not the other? I am going to change to
> Me.Refresh most places now, but I am still curious.
>
> Thanks,
>
> Andrew Backer

Relevant Pages

  • Re: Diff between refresh & requery
    ... >"The Refresh method shows only changes made to records in the current set. ... >been deleted since the database was last requeried. ... >requery the database, use the Requery method. ... >data in the record source." ...
    (microsoft.public.access.formscoding)
  • Re: Diff between refresh & requery
    ... >"The Refresh method shows only changes made to records in the current set. ... >been deleted since the database was last requeried. ... >requery the database, use the Requery method. ... >data in the record source." ...
    (microsoft.public.access.forms)
  • Re: New record problem in sub-form
    ... The Refresh method shows only changes made to records in the current set. ... Since the Refresh method doesn't actually requery the database, ... data in the record source. ...
    (microsoft.public.access.forms)
  • Re: Diff between refresh & requery
    ... "The Refresh method shows only changes made to records in the current set. ... Since the Refresh method doesn't actually requery the database, ... data in the record source." ...
    (microsoft.public.access.forms)
  • Re: Requery "Too Soon"?
    ... "The database has been placed in a state by user ... then the Requery will return the just ... MsgBox appears, I get an empty subform, i.e., I do ... I'll try inserting a DoEvents or two. ...
    (microsoft.public.access.formscoding)
Quantcast