Automatic Update on Forms

[sandellma]

Hi,

I am trying to display a message when a user is about to update a field within a form in ms access (2000 and 97) and moving to the next record, the warning will need to be able to either stop the update or allow the update to proceed.

Any suggestions would be greatly appreciated.

Thanks in advance.

Michael ... please reply to sandell@flashmail.com as well as this posting.

 

[jrbarnett]

This is a simple example using the beforeupdate event on a textbox which can be cancelled.

Private Sub textbox_BeforeUpdate (Cancel As Integer)

  If Msgbox ("Do you want to save the data", vbQuestion+vbYesNo) = vbNo Then
     Cancel = True
  End If

End Sub

John

 

[jrbarnett]

Sorry - the End Sub should also be part of the code segment.