Event Handling in Access 2000 1

[cpsqlrwn]

I need to determine which control or form event to use to interrupt the save process after leaving the last field in a form. I want to provide a user confirmation for saving the record with an option for canceling back into the form to resume editing.

 

[njonsie]

I don't know the answer to this question, but I do know that typically Acces employs record level locking. Record level locking saves each record in each field as they are typed. You may be able to add a dialog box that asks if the information is correct, but record level locking will have to be altered, or atleast I assume.

Another Idea is to add a check box to the form as the last tabed field. It could ask if the infomation is correct. If they click no you could easily pick the information out or possibly add an event if the checkbox = no.

Either way, I'll pay attention to this post to see what comes of it. Good Luck.

Nathan

 

[JoeAtWork]

You can do this in the form's BeforeUpdate event

Private Sub Form_BeforeUpdate(Cancel As Integer)
    'Call the validation subroutine, and if it doesn't 
    'validate, abort saving changes
    If ValidateForm = False Then
        Cancel = True
    End If
End Sub