If I am evaluating a current record in a table, is it possible to delete the entire row in which it exists in.

Example:
Do While Not rstTempWip.BOF
            If rstTempWip("Status").Value <> "Completed" Then
    'HERE IS WHERE I JUST WANT TO DELETE THE ENTER RECORD ROW since the entire line item is considered completed.

           With rstTempWip
                .Edit
                .Delete
                .Update
            End With
            End If
        rstTempWip.MovePrevious
        Loop

I would do this with a Delete query. Create the delete query and in the column with the Completed value, enter the value that should condition the delete. This will delete the entire record.

Then just do this on your code:

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryDELETEComplete"
DoCmd.SetWarnings True

Did that help?



mmcdonal