I would expect the following code to delete all the records in a form's
underlying recordset, and delete the rows in the form. But the form's rows
are still there, and when I scroll the form, the field's values display
'#Deleted'. Thank you for the help.

Dim strSQL As String
strSQL = "DELETE * FROM " & Me.Recordset.Name
CurrentDb().Execute strSQL
Me.Requery

"Tim Tabor" <tltabor@nyc.rr.com> wrote in message news:<8phBc.83374$mX.28408744@twister.nyc.rr.com>. ..[color=blue]
> I would expect the following code to delete all the records in a form's
> underlying recordset, and delete the rows in the form. But the form's rows
> are still there, and when I scroll the form, the field's values display
> '#Deleted'. Thank you for the help.
>
> Dim strSQL As String
> strSQL = "DELETE * FROM " & Me.Recordset.Name
> CurrentDb().Execute strSQL
> Me.Requery[/color]

Add Me.Repaint after Me.Requery.