Konichiwa, VBA to Edit Current Data with ID number assigned.

[sorensjp]

Hello,

I'm creating a Leave and Liberty Tracker using a Template and code provided by Trevor Easton from http://www.onlinepclearning.com/. The designer places all of the Templates and code on his site for free to use. The problem I'm having is he didn't provide the code to "Edit Existing" Macro for a Booking or in my case a Leave or Liberty request. I've been able to change and add to the code from the original http://www.onlinepclearning.com/exce...ooking-system/.

I attempted to use the AddMe macro as a starting point to accomplish the task but am unable to make to correct changes to update a selected item.

Thank you in advance for any assistance.

Jim

[AlphaFrog]

You should have used the DeleteMe macro as a starting point. It finds the row in the database that matches the ID. Then instead of deleting the row, you update the values.

Please Login or Register  to view this content.

[sorensjp]

AlphaFrog--

Thank you that did the trick. I had bee playing with that for a couple days and got nowhere. You hit it right on. Thank you again.

Jim

[AlphaFrog]

You're welcome. Thanks for the feedback.