Re: New record problem in sub-form

Wow! I did remember correctly! I'm always amazed when that happens!

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.

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

Answers/posts based on Access 2000/2003

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

.

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: 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.formscoding)
  • 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: How can i delete a record?
    ... 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. ... When the record source for a form is requeried, the current set of records will accurately reflect all data in the record source. ...
    (comp.databases.ms-access)