Trouble with saving user input in an Excel Form.
 

I am having trouble saving data into a forms datasheet. It appears that I am
missing a crucial step when trying to save 'new' data to the datasheet.

Steps:
1. I open the form in 'form view' and enter data within the
datafields.
2. I save the existing data using the macro 'save.'
3. I reset the datafields and enter new data.
4. I save the form assuming that the data I have just entered is
being saved
as a new row, however upon opening the datasheet I find that the
data I
had previously saved has only been overwritten by the data I have
just
saved.

Unfotunatley, I don't have the experience with Excel to solve this problem.
I have used the Excel 'help,' but I could not find an article that relates to
my situation.

Any ideas?

Many Thanks.