I have a form that tracks personnel and I have created a button on that form
to delete the personnel record if that employee leaves.  When I do click
this button (since I have 3 other sub forms with cascade deletes turned on)
I get a message notifying me that "multiple records will be deleted..."  Is
there a way to customize this message?  If so how and where do I do it?

--
Chad Atchley
University of Oklahoma
MIS Senior

Put code in Form_Delete event, check in help on this and a few other events
that occur when
deleting, so you can cancel the deletion or confirm it without user
intervention

___D U H !! ____

Thanks once again Terry for catching that stupid mistake :-)

Documentation?? Hey I thought developer's philosophy was "If it was hard to
code, it should be danged harder to use..." Right? :-)

Thanks
Dev

--
Dev Ashish
---------------

:Hi Dev
:
:should also have been
:
:         strMsg = "Are you sure you want to Delete this record?"
:         If MsgBox(strMsg, vbQuestion + vbYesNo) = vbYes Then
:
:You were asking them if they wanted to delete the record, and if they said
:No you were deleting it.  Mind you if you documented this as a feature of
:your system I suppose it would be OK <g>.
:
:
:>>        'Disbale the default system warning
:>>        docmd.setwarnings False
:>>         strMsg = "Are you sure you want to Delete this record?"
:>>         If MsgBox(strMsg, vbQuestion + vbYesNo) = vbNo Then
:>>            'Delete the record
:>>            dbengine.RunSQL "Delete ...... from tablename";
:>>        end if