Saving data to a form datasheet
 

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 again 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.

Many Thanks.