Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003

    Question Unanswered: Lock previous record once new record is entered

    I have created a database where the users enter data into a form and then print out the corresponding report.

    Is it possible to lock the previous record once a new record is initiated? Some users are overwiriting existing records.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    If they don't need to read access to existing records, you could set your form's "data entry" property to true.

    You could store a public boolean variable to reference the relative state of the current record (new vs. pre-existing)

    You could provide seperate forms for adding and viewing data, the former with "data entry" set to true and the latter being an un-updatable snapshot...

    There's just a few options...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Apr 2003
    Alabama, USA
    Don't know if this is helpful or not but someone awhile back asked a question about how to prevent a record from being edited if today's date was greater or equal to a date field for the record so I came up with an article & sample. Maybe it'll be helpfull.

    You live and learn. At any rate, you live. - Douglas Adams

Posting Permissions

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