Save Record Prompt

[Grimmers]

I have a membership database that my users manage to delete records without realising as they are computer "nuff nuffs". My main form has membership details with a tab control and a linked subforms on each of 3 pages, members, payments, boats. I am trying to find a way to prompt for save or discard changes when a record is changed. I have looked at a couple of ideas that only really apply to a standalone form but really need a solution that cascades across the subforms as well.
Hoping for some help,

Regards,

David

 

[SQL_Hell]

I am trying to find a way to prompt for save or discard changes when a record is changed

Is this when the current user changes records or when another user changes the current record?????

I think msgboxes and recordsets are going to be the best way for you achieve this.

 

[monkeytunes]

I have looked at a couple of ideas that only really apply to a standalone form but really need a solution that cascades across the subforms as well.

If you want Access to always ask you about record changes, you can go to Tools->Options->Edit/Find tab and then click the appropriate options in the "Confirm" area.

If that's not what you're looking for, you can use some of the "Confirm Changes" code found elsewhere on these boards and put it in the "Before Update" properties on your form and your subform. It's a bit clunky, because it will ask you for confirmation twice if you change stuff in the subform and the main form, but it works.