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