Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Canceling a table addition

    I have a form which adds some info to a table, it creates the key and everything. What I wanna do is set it so it will cancel the addition to the table (and delete the new key and everything) if a certain subform is empty.
    How can I do it?

  2. #2
    Join Date
    Apr 2002
    In certain situations I like to have complete control over the info being entered for new records. Here's one of my approaches:

    Create an unbound form with all necessary fields. Have a button to add the info. Within the click event for the button, do any data validation and then add the info to the table using VBA.

    If you don't like that approach, read up on a form's BeforeUpdate event in online help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts