ignoring access warning messages

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a form with two subforms. When one subform is shown and I click
reset the subform controls are reset and the main forms controls are reset.
When the two subforms are shown and I click the reset button the message
"are you sure you want to delete this record appears"

How do I stop showing this meassage?

Code

Me.txtSoaid.SetFocus ' pk textbok

DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
ResetControlsSub frmCreditor ' 1st subform
ResetControlsSub frmDebtCollection '2nd subform


When a record is about to be deleted an access message is appearing to say
"Do you wish to delete this record"
 
DoCmd.SetWarnings False before you run the code, DoCmd.SetWarnings True
afterwards.
 
Hi Chris,

Look in Help for SetWarnings.Set warnings off just before you delete and
then remember to turn them on again immediately after the operation. Many
warnings are affected so turn them back on!

HTH
 
Back
Top