B
bobdydd
Access 2000 Windows XP
Hi Everybody
I have got a weird one here.
I have a large form frmTransactions based on a single table
tblTransactions.
There are a lot of fields on the form but everything works OK. That is
until you want to delete a record on the EOF that not much data has
been entered. Where the user has started a new record without
completing it and just got the TransactionID entered.
So now I want them to be able to delete this record:
I have tried
DoCmd.RunCommand acCmdDeleteRecord
and I've tried
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
But no joy.
Now here is the strange bit. As I delete this record it ADDs another
one with the autonumber, and I actually see one TransactionID disappear
and a higher one appear. Twighlight Zone stuff I think.
THis not happening with another form that I experimented with, or on
the table itself.
Any help would be most appreciated.
Bob
Hi Everybody
I have got a weird one here.
I have a large form frmTransactions based on a single table
tblTransactions.
There are a lot of fields on the form but everything works OK. That is
until you want to delete a record on the EOF that not much data has
been entered. Where the user has started a new record without
completing it and just got the TransactionID entered.
So now I want them to be able to delete this record:
I have tried
DoCmd.RunCommand acCmdDeleteRecord
and I've tried
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
But no joy.
Now here is the strange bit. As I delete this record it ADDs another
one with the autonumber, and I actually see one TransactionID disappear
and a higher one appear. Twighlight Zone stuff I think.
THis not happening with another form that I experimented with, or on
the table itself.
Any help would be most appreciated.
Bob