How to create Check In Form for a list of item in Access

[zwyp]

I'm creating an access database as my tools loaning system.

I'd create a tools table contain:
ToolingID
Description
Location
This table is mainly used as my tooling list database

Transaction table contain:
TransactionID
ToolingID
Checked Out by
Checked Out date
Checked Out to
Checked In by
Checked In date
Checked In to
This table is mainly used as transaction history include checked out but not checked in yet

Current Transaction Query contain tools that had been checked out but not checked in yet

I'd create a Checked In Form contain toolingID, Checked In by, Checked In date and Checked In to.

My problem is how can the ToolingID to be appear in this form provided that my RecordSource is Transaction table but not Current Transaction Query?

Do anyone have any thought on this?

[NeoPa]

I guess the first, and most obvious question is :
Why does your Form have to be based on the Transaction Table and not the Current Transaction Query?

Other than that of course, Forms can be filtered and sorted too. I see no problem with anything you've explained - except why you're asking for help. It isn't clear what your problem is.