Results 1 to 2 of 2
  1. #1
    Lupson2011 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    68

    Creation of additional empty

    Hi, I posted something recently, but hopefully I might explain it a bit concisely this time!

    I have a parent form and a subform. I choose a year end from the parent form (eg. 2008/2009).



    In the subform there are four tabs, each containing a different form and each linked to the 'year end' you choose in the parent form.

    I am able to complete all the data entry fine, it all links back, etc..but when I exit out of the parent form to the previous form and back again, an empty addition record is created for the same year end. For example for 2008/2009 I have one record that is data full and the other that is completely empty. Each as its own unique ID?

    How do I stop this? so these records stop being created? Any advice greatly appreciated

    Lupson2011

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    This has to do with the code you're running and nobody's going to be able to tell you how to fix it without an example of the code. The only thing you can do independent of that that I can think of is to set up some required fields in your table so that a blank record can NOT be possible (set a required value to yes on a field at the table level).

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

Similar Threads

  1. Append additional information to a field
    By Lorlai in forum Access
    Replies: 6
    Last Post: 07-15-2011, 11:09 AM
  2. additional detail records to be inserted
    By Mclaren in forum Reports
    Replies: 1
    Last Post: 03-16-2011, 02:10 AM
  3. Adding an additional WHERE clause
    By Pells in forum Queries
    Replies: 7
    Last Post: 10-28-2010, 12:44 PM
  4. Additional params for ANY query
    By dnagir in forum Access
    Replies: 0
    Last Post: 01-21-2009, 10:05 PM
  5. Will Pay $$$ for help w/ database creation!
    By eyesbryte in forum Access
    Replies: 1
    Last Post: 07-03-2006, 01:56 PM

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