Delete a record row, not just the record.
If I am evaluating a current record in a table, is it possible to delete the entire row in which it exists in.
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.