After delete, No current Record and #Delete

[James T]

Access 2000

Using the wizard to put a button on a form to delete the
current record (code on click), I am getting a dialog
box "No Current Record" and the record shows up as
#Deleted.
The strange thing is that this happens on my machine, but
if I go to a co workers computer, it works fine.

Any help appreciated.

James

Private Sub Command27_Click()
On Error GoTo Err_Command27_Click

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, ,
acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, ,
acMenuVer70

Exit_Command27_Click:
Exit Sub

Err_Command27_Click:
MsgBox Err.Description
Resume Exit_Command27_Click

End Sub

 

[Geof Wyght]

James,
Does this happen when you both have the same form open?
Geof Wyght

 

[James T.]

Yes it does. I have looked for solutions on the #Delete
error, and have tried several, but no success.

James

 

[Geof Wyght]

James,
I should have also asked that if only one of you has this
form open, there aren't any problems? I'm leaning towards
a record locking solution.
Geof Wyght.

 

[James T.]

Geof,
No, it is stange, it only happens on my computer, and I am
the one trying to get the coding right before we let it
loose in our office. I have only tried it on one other
computer.

James

 

[Geof Wyght]

James,
Try Google with the key words:
"access" + "wizard" + "delete record" + "No Current Record"
Look at the 3rd response from Allen Browne, an Access MVP.
Geof Wyght