Userform is not working properly

I have created a userform but it is not working properly.

It is very straight forward, there are 3 sheets. One is SWDashboard where there is a button to activate the form. The Second is SWDatabase where all the info of the userform will saved. And 3) the SWMaster where the userform gets all the info.

Problems I am experiencing and I need help in is the following.

1) When I click on the button on the SWDashboard sheet and I start playing with the buttons it is not saving in the correct sheet. For example if I select, view last row nothing appears. Or if I press submit it enters the data in the wrong worksheet.

2) I want to do a validation where the Qty IN = as the QTY OUT + QA/Retains + All the rejects. If this statement is not true to give a message box saying "Please verify that the quantities are correct.

3) The date is not appearing either when I open the form.

Thanks for your help.

It didn't work for some reason. It is still not working. I have added that reference in the With Sheets("SWDatabase") ... End With and it is still not working for some reason.

Yes i did look.1.PNG

Any particular reason you go get the last used row in Col A, then add 1 and use that as the source...?

Maybe I misunderstand, but getting the last used row does just that. Anything below it is blank as it's after the last used row.

So when the userform opens I want for the fields to be empty except for the date that I want it to be populated automatically. And then it depends what I want to do. So for example if I click on View Last Row, I want to see that last row inputted in the SWDatabase worksheet. If I put submit I want for the information to be added after the last row. If I put previous, I would like to show me first the last row, If I click previous again, then it starts going up to the previous row. If I put next then it will bring you to the next row. If it is in the last row it will tell you, that you are in the last row. I just want when the form initialize that all the buttons work and all data will be sent, saved and update the database.

Thank you now it is working. Thanks a lot

And the last question that I did on my first post is still missing, how can I do the verification calculation in the form so Qty IN has to be equal to Qty Out + QA/Retains + All the rejects?

Capture.PNG

So basically i want to make sure that the qty in is the same number as the summation of qty out + QA/retains + all the rejects like LCP Stains, LCP Flash, etc...And if this summation is not equal to Qty in then to give me a message saying to check the numbers.