Vba-interactive userform to input/view/update data in table

I have been beating my head against the wall trying to find code that will allow my userform to be more interactive--I want it to not only load info into my spreadsheet, but also want to use it to view the existing records, update them and delete them were necessary.

I have attached my workbook--the form in question is Form 1, I want users to be able to search by complaint number (textbox 1) and load the matching record, so it can be updated, deleted or left as is. I also have code for that textbox because if the user is not looking for an existing record, but rather creating a new one, it should auto-load the next sequential number.

I understand I will have to add command buttons for Update, delete, < and > to scroll through the existing records. I have tried MANY different vba codes and tried to adapt them to my use, but none worked, so I have removed all the code and buttons to start fresh.

ALSO--I have date user fills in using form 5 to populate criteria on Sheet 12 (I now use a calendar pop-up rather than a manually input date). Sheet 12 criteria is used to autofilter records from Sheet 8 and posts the report on Sheet 13. I have problems with the dates not working. Everything else filters fine, but the dates are not recognized it seems. I tried changing the date format on Sheet 12 and 13, but cannot figure this one out. **would LOVE to attach the updated workbook, but it is too big now.

Your help is most appreciated!

sorry--here it is