Difference between Refresh and Record Save....

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

I would like to know what the difference is between Refresh and Save Record.

When should I use each? How each works with Unsaved Records? If I click on
each which one(s) will keep me on the same record, but (Refersh and/or Save
Data)


Thanks,

Rog
 
Hi Roger,

Refresh: refreshes the FORM;

SaveRecord: saves the underlying RECORD.
 
I figured this, but wanted more detail as to what exactly each does doesn't
do.

Refresh actually saves the record too, then refreshed the form. Is there an
actual definition of what refresh does?
 
Roger said:
I would like to know what the difference is between Refresh and Save
Record.

When should I use each? How each works with Unsaved Records? If I
click on each which one(s) will keep me on the same record, but
(Refersh and/or Save Data)


Thanks,

Rog
Click to expand...

Refresh will also pick up changes to records besides the one you are
currently looking at. Not insertions and deletions, but edits only. To get
insertions and deletions you would use Requery.
 
Roger said:
I figured this, but wanted more detail as to what exactly each does
doesn't do.

Refresh actually saves the record too, then refreshed the form. Is
there an actual definition of what refresh does?
Click to expand...

Refresh saves the current record, if it's dirty, then goes back to the
database to get the latest, possibly updated data for all the records
currently in the form's recordset. Here's the Access 2002 help topic on
the subject:

<quote from Help>
Refresh Method

The Refresh method immediately updates the records in the underlying
record source for a specified form or datasheet to reflect changes made
to the data by you and other users in a multiuser environment.

expression.Refresh

expression Required. An expression that returns one of the objects
in the Applies To list.

Remarks
Using the Refresh method is equivalent to clicking Refresh on the
Records menu.

Microsoft Access refreshes records automatically, based on the Refresh
Interval setting on the Advanced tab of the Options dialog box,
available by clicking Options on the Tools menu. ODBC data sources are
refreshed based on the ODBC Refresh Interval setting on the Advanced tab
of the Options dialog box. You can use the Refresh method to view
changes that have been made to the current set of records in a form or
datasheet since the record source underlying the form or datasheet was
last refreshed.

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.

Notes

It's often faster to refresh a form or datasheet than to requery it.
This is especially true if the initial query was slow to run.

Don't confuse the Refresh method with the Repaint method, which
repaints the screen with any pending visual changes.

</quote from Help>
 
Back
Top