Using VBA for two different data entry forms, works correctly in one and not the other

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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

I'm very new to doing this, so feel it's a very simple solution, but I can't figure it out.
Any help will be appreciated.

Thanks

You're using column A to find the next row but you're not putting any data in there. Try this instead:

Please Login or Register  to view this content.

WBD