Check Out - Lending Library

[Surferboy1500]

Hello,



I've been updating the "Lending Library" template from access to fit my needs. Unfortunately, during my updating, I messed up the "check-out" function on the "coral list" (previously "Asset List").

Now when I use the check-out function, it doesn't assign the check-out to the asset I'm clicked on (which causes issues with the query that runs to determine if they are in check-out or check-in mode).

Can someone help me fix this issue?

[June7]

One issue, in my view, with those MS Access templates is they are designed with macros. I don't use macros, too hard to debug, prefer VBA. So I compared the Transactions macro in both the original template and your project. Appears to be a missing If Then structure. Since I don't really know how to build macros and don't want to learn, I deleted Transactions from your project and imported from the original. Also, on your CheckOut form, the hidden textbox called Asset is bound to the wrong field, should be Asset field. Now CheckOut works.

[Surferboy1500]

June,

Thanks for helping me with that.