deleting row from continuous form

A

AlexD

I'm using a continuous form and using recordset to edit
and delete the rows.
After deleting I have #Deleted in texboxes on the Form.
How could I delete this deleted row from the Form as well?
Thanks

With rst
If intRecordCount <> 0 Then
RunCommand acCmdSaveRecord

.MoveFirst

While Not .EOF
If ... Then
.Edit
...................
If ![RecUnits] = 0 And ![RecKG] = 0 Then

Msg = MsgBox("If ....", vbOKCancel)

If Msg = 1 Then
.Delete
??????????
Else
rst.Close
dbs.Close
Exit Sub
End If
Else
.Update
End If
intDoEvents = DoEvents()
End If
.MoveNext
Wend
End If
End With
Me.Repaint
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top