Entering Data in Table using a Form

Hello Guys

I'm looking for some help in inputting data into a table using a form.

I have created a form and written some code to input data into a form, however the data is being inserted into the correct columns but not the next empty row, instead its being entered
at the bottom of the table.

Initially, this was working correctly, but something has gone wrong somewhere. I'm completely new to VBA code.

Thanks guys

Martin

Here is a sample file to study and work off from :

Please Login or Register  to view this content.

Good afternoon everyone

Than you kindly for all your help with my excel project.
My spreadsheet is beginning to grow arms and legs and as I learn more I find out ways to enhance my spreadsheet into a nice little database.

Can I ask for some help with adding a combo box under the Nav status.
I’d like this to contain 4 items as follows Underway, At Anchor, Local Pilot, With Tugs
I’ve used the add item code, but I’m not sure its correct.
As I add a new row in my table I’d like to add a “Yes” into one of the columns in the OpsRecord sheet.
For example if I select Underway in the combo box and click add new record button, I should have a Yes in the underway column on that row and the other columns to the right should remain empty.
Can someone help me?
Thank you

Martin