Results 1 to 3 of 3
  1. #1
    Remster is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    317

    Suppressing the new record until the previous record has been completed

    Please see MyForm in the attached sample database. As soon as you type a character in the new record (which will be ID 4), a second new record appears (which will be ID 5). I realise this is standard Access behaviour.

    Is there any way of suppressing the second new record until the first new record has been completed? I've tried using the form's On Dirty event to set AllowAdditions to 'False', but this simply removes the first new record.



    MyDatabase.accdb

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    You could have an unbound form and use insert SQL to create the record.
    Last edited by davegri; 11-23-2018 at 10:29 AM. Reason: added db

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Quote Originally Posted by Remster View Post

    ...As soon as you type a character in the new record...a second new record appears...
    You have to understand that you're not actually seeing a 'new Record!' While the Access Gnomes have presented what appears to be a new Record, it's actually only framework for a new Record, if you will! It will only become a new Record if, once again, you enter a single character into one of its Controls!

    To keep your user from moving to a new Record, before completing their current Record, you need to have validation, insuring that all Controls, in the current Record, are populated/saved first.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-11-2015, 10:31 AM
  2. Replies: 8
    Last Post: 07-06-2013, 05:13 PM
  3. Replies: 5
    Last Post: 06-16-2013, 05:25 PM
  4. Replies: 22
    Last Post: 06-12-2012, 10:02 PM
  5. Replies: 3
    Last Post: 11-23-2011, 12:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums