Hi,
I created a data entry form in VBA that adds entries to a database.
I used almost exactly the same code for both, with the only differences being the database locations and the names of the entry forms.
In one of the data entry forms, the code works correctly and a new row is added for each entry into the form.
The code for the correct one:
For the other entry form that links to a seperate sheet, the entries to the form replace the previous entry, rather than making a new row.Please Login or Register to view this content.
Obviously I want it to create a new line for each entry into the form, yet it doesn't do this.
The code for this one:
I'm very new to doing this, so feel it's a very simple solution, but I can't figure it out.Please Login or Register to view this content.
Any help will be appreciated.
Thanks
Bookmarks