Save button for saving new record and update changes (Urgent! Thanks!)

[smallWorld]

Hi all,

My form has a SAVE button that will update an record should there be changes to a valid record in table. Everything about the employee can be modify except EmployeeID.

This SAVE button should also can insert new record if there are no existing record in the table.

1) How do I check all the values in all controls to find out if there is any changes to update, using EmployeeID? The reason to use EmployeeID is because there should be such a EmployeeID to ensure there are relevant record to update.

2) If there isn't such an employeeID, then insert new record.

Anyone knows how to code this button?

Thanks!

1) Display the last record in combo box.

2) After the user click on the EDIT button and click on the down arrow of the combo box. It has to let user select the list of countries/ cities from tblAll table, while still appearing the last record value. E.g.: When user click on down arroe of country combo box, it display the list (E.g.: France & USA), while highlighting the last record value of France.

3) How to have password validation before we allows deletion?

Thanks!