rockies1
06-06-2002, 11:27 AM
How can I either prevent or trap when someone is trying to delete a record using my form by clicking Edit/Delete Record or the red >X on the toolbar?
I don't want users deleting records!!
Thanks!
Pat Hartman
06-06-2002, 11:34 AM
The BeforeDelete event is fired before any record is deleted. You can cancel the Delete event and display a message. However, this only works for forms. If your users have direct access to tables or queries, you would need to implement Access security to remove their permission to delete data.
rockies1
06-06-2002, 11:38 AM
Thank you so much!!
Once again, you have saved my skin!