Re: How can i delete a record?



Nick 'The Database Guy' wrote:
Hi Allen,

I can't beleive how long this saga has become.

If after you delete the record you simply insert the line:

Me.Refresh

Have you tested this?

From the online 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.

Perhaps you meant Requery? This is a common mistake.

'---------------
'John Mishefske
'---------------
.



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: 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)