Lending Library Help

[Dustin]

Hi,
I downloaded the Lending Library Template and have a problem where is does
not pick up the right item when i want to sign it back in. It picks up the
first item that was borrowed out all the time.
Any help?

 

[StarlessKnight]

Go to the "Design View" of the "Check In" supporting object. In the property
sheet of the form right click inside the "Record Source" field's value,
select Zoom. Replace what's there with this:

SELECT Transactions.*, Assets.* FROM Assets INNER JOIN Transactions ON
Assets.[ID]=Transactions.[Asset] WHERE (Transactions.[Checked In Date]) Is
Null And [TempVars]![ItemID]=Transactions.[Asset];

Hope this works for you, as well. Took me a lot of trial-and-error to fix it