Results 1 to 2 of 2
  1. #1
    cottonland is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Apr 2016
    Posts
    9

    Eliminate empty row in table

    I have a form (Locations) in which all controls are bound to a Table (Locations Table). The on click command for my Add Button is " DoCmd.GoToRecord , "", acNewRec ". I then have a next button which closes the form and opens the following form. My problem is that after adding the record, when I click the Next button, it results in an additional record in my table where the values are all blank.

    How do I eliminate the empty record in the table?

    ID Quote ID Account Name Loc # Description City St Zip County Acres Miles FD PC locName
    43 MG53256
    1 2 Miles NW of Lake Village Lake Village AR 71653 Chicot 2500 4 6 Main Location
    44 MG53256


    2 4 Miles E of Lake Village Lake Village AR 71653 Chicot 3600 8 10 Second Location
    45 MG53256











  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    It looks like something in your code is putting a value into QuoteID before you close the form. Any unsaved data on the form is saved when it is closed.
    You could try this in your NEXT button code before you close the form.
    If ME.Dirty = true then me.Undo

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

Similar Threads

  1. Replies: 5
    Last Post: 06-13-2013, 08:42 AM
  2. Replies: 2
    Last Post: 04-23-2012, 10:13 PM
  3. check empty table
    By ramdandi in forum Queries
    Replies: 1
    Last Post: 12-20-2011, 04:31 PM
  4. Replies: 4
    Last Post: 11-20-2011, 01:08 PM
  5. Deleting empty columns from a table
    By kapil0712 in forum Programming
    Replies: 3
    Last Post: 05-17-2010, 12:35 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