Re: Form refresh

As is evidenced here, much about Refresh is unclear. Per Help in Access 2000:

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

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."*

I take this to mean that Refresh should only be used in a multi-user
environment, and that even there it is of limited use. I think in this case
that Me.Requery would probably be better than Me.Refresh.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1

.