Hi Everyone, I am not only new to this forum but new to Access VBA. I have taught myself a fair bit but am struggling with a situation where the form save button does not add a new record to the relative table, but simply overwrites the data on the same row.
I discovered that using the undersized "Add New (Blank) record button at the bottom of the form window works fine and when I view the table, all the test records are added as new records. I cant seem to get the same result using a button.
Any ideas are most welcome with great thanks for your time. I am sure its an easy fix.
Darren

Darren, it always helps to provide code for what you are having problems with. I am assuming you have VBA code to launch on the Save button's On Click event, but am only guessing. Do you have VBA code for the form's On Load event? What does your Property Sheet show for RecordSource? RowSource? Data Entry? Allow Additions? Help us help you.