Delete a record on a bound form...

[rockies1]

I have a bound form using a DataControl.

I need to be able to click a button and delete the current record and then move to the next record (or the previous record if there is no next record)

When I try:

Private Sub Command2_Click()
    Data1.Recordset.Delete
    Data1.Recordset.MoveNext
End Sub

I get error # 3426 reading: This action was cancelled by an associated object.

How can I make this work?

Thanks!

[oh1mie]

Originally posted by rockies1
I have a bound form using a DataControl.

I need to be able to click a button and delete the current record and then move to the next record (or the previous record if there is no next record)

When I try:

Private Sub Command2_Click()
    Data1.Recordset.Delete
    Data1.Recordset.MoveNext
End Sub

I get error # 3426 reading: This action was cancelled by an associated object.

How can I make this work?

Thanks!

Properties window - Read only -> true ???

[rockies1]

No.

In fact, it does delete the record, it just doesn't let me move after it does...