Delete Button won't work

[Arjay418]

Hi everyone,

In one of my forms (it's actually a subform) I use a "Delete" button to delete a record. It has a "delete record" macro in the OnClick event. Seemingly out of the blue, this button began to act up. When I click it, I get the usual warning that Access is about to delete 1 record. I choose OK, and the item goes away. But it reappears if I close the form and reopen it. I can successfully delete the record if I go to the original table and delete it there. I just wish I could delete the records using the delete button on the form.

Any ideas?

--RJ

 

[Rolliee]

If you have involked referential intergity with an associated table/ field, you cannot just delete anytime. It would leave orphans. I do not know if this explains it or not. Also there should have been an err message.

rollie@bwsys.net