Lending Library Error Access 2007

[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]

I've noticed your inquiry about this in several places, so here's what I
finally discovered, myself, after plenty of bumbling about:

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];

I hope this helps resolve the problem with this template for you.