Deleting the current record with Form's On Close event

[Nevermoor]

Hi,

I have a form that uses dynamic default values (form's values are all entered based on the last record's values). There is only one drawback though, the form will automatically fill out the record after the last one entered thus creating a duplicate value.

I have appropriate markers to make sure that only duplicate records are deleted, but the normal deleting code won't work in the On Close event. The error says:

"Run-time error '2046'
"The command or action 'SelectRecord' isn't available now."

The Code I tried is:

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

 

[TrojanRabbit]

Try DoCmd.RunCommand acCmdDeleteRecord.

 

[Nevermoor]

That generates the same error.

I have no idea why these commands aren't available during On Close, but they don't seem to be

 

[Nevermoor]

That brings up the same error

I have no idea why these commands aren't available during the On Close event, but they just don't seem to be.

 

[TrojanRabbit]

It seems that, when it's told to close, it doesn't keep track of the current record anymore. I set up a msgbox in OnClose to tell the values of a couple records. It would give the values from the first record rather than what was the current record.

Thus, I can think of a couple alternatives.

1) Use a recordset object to open the source of the form, find the duplicate, and delete it. This does not involve the form, so closing shouldn't affect it.

2) Force users to use a command button to close. Put in the delete commands before closing the form.

 

[wkendrvr]

2) Force users to use a command button to close. Put in the delete commands before closing the form.

Had to use the same method.

 

[Nevermoor]

Thanks guys!

too bad it has to work that way though