Results 1 to 3 of 3
  1. #1
    floyd is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    66

    Stop input form from creating blank forms

    I am having troubles with forms creating blank database information.
    It seems every time a form is opened and then someone goes to a new form, there is a blank record created.

    How can I prevent this?

    This is a bound form with a "save" button.



    I know that there are things that can be done with "beforeupdate" but it seems like every time I try something it causes more problems than solutions.

    Any help would be appreciated.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by floyd View Post

    This is a bound form with a "save" button.
    If you just navigate to a new record and then close the form, there will not be a "New" record in the table. Navigating to a new record will display fields that are null. If you do not change anything, the fields remain as null. A record will not be created.

    You must be doing something after navigating to a new record. If you can exit and close the form before doing something, not quite sure what is being done, the record will never become a record. You need to identify what event is causing the record to be created.

  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,018
    Quote Originally Posted by ItsMe View Post

    ...If you just navigate to a new record and then close the form, there will not be a "New" record in the table...

    ...If you do not change anything, the fields remain as null. A record will not be created
    ...
    This was explained to you here:

    https://www.accessforums.net/program...ing-39261.html

    Reposting the question is not going to change the answer!

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

Similar Threads

  1. Input Forms - How To Input Multiple Fields/Records?
    By butterbescotch in forum Forms
    Replies: 1
    Last Post: 04-04-2013, 06:30 AM
  2. Stop Form from opening when query is blank
    By anpmm2 in forum Access
    Replies: 1
    Last Post: 12-16-2011, 04:18 PM
  3. Creating a input form...?
    By DarrenReeder in forum Access
    Replies: 4
    Last Post: 01-07-2011, 03:26 PM
  4. Replies: 2
    Last Post: 11-29-2009, 12:00 PM
  5. Creating input forms for queries?
    By Brujeria5 in forum Queries
    Replies: 1
    Last Post: 08-14-2009, 08:48 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