is it possible to cancel insert and not lose data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is it possible to cancel an insert on a form and still allow the user to edit
what was already entered?

i would like this to happen once all the data is entered and the user tries
to go to the next record.

thanks.
 
Hi, Ben.

Use the form's BeforeUpdate( ) event to determine whether the user needs to
finish editing before proceding to the next record. For example, try:

Private Sub Form_BeforeUpdate(Cancel As Integer)

On Error GoTo ErrHandler

If (Nz(Me!txtNum.Value, "") = "") Then
Cancel = True
MsgBox "Please fill in the number ordered.", _
vbCritical + vbOKOnly, "Can't Continue!"
End If

Exit Sub

ErrHandler:

MsgBox "Error in Form_BeforeUpdate( ) in" & vbCrLf & _
Me.Name & " form." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
Err.Clear

End Sub

.. . . where txtNum is the name of the text box that must be filled in prior
to proceding to another record.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
I understand what you are saying, but my situation is more complet. Once the
entire form is filled in, I need it to somehow check that it is a valid entry
and then insert the data. I guess i can just tell it to insert the data, run
a query and then if the query returns bad results delete the inserted record
and report an error to the user..

thanks anyways.
 
Hello Ben

To validate the data entry for a field I use the LOST FOCUS event of the
field.
If the data is not valid then I display a suitable error message and force
the user back to the field
 
Back
Top