University of Maine student
Guest
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.
Bookmarks