Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Dallas TX
    Posts
    1

    Question Unanswered: Access2000 - Data Entry Form Help

    How can I create a form that allows multiple records from the same table to be keyed with data validation occuring before the records are saved to the table? I have a trip sheet to enter that has odometer/mileage readings at state line crossings. I need to validate the total miles by state that are keyed to the total miles calculated from begining and ending odometer readings of the trip before all the records are saved to the table.

    Any advice is appreciated!

  2. #2
    Join Date
    Jan 2002
    Location
    At the Edge of America!
    Posts
    55
    You want to use the Before Insert Event of the form. This will let you validate any control on the form before it is inserted into the table.

Posting Permissions

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