I am using MS Access 2007 under MS Windows 10 Home x64. I have created a form for handling an inventory item in my project. This is an item issued to "Borrower." The issuing form identifies the LoanID, the "Issuer", "Borrower", item properties, date of issue and due date for return, then creating a record of this transaction. When the item is returned, I have another form which uses input of the LoanID to populate the form with data from the saved transaction record and updating using the currently logged on "UserIDIn" and date to update the form. Apparently, I have not correctly defined the LoanID on the "return" form such that it looks at the Loaned transaction to find the relevant data for populating the form. I need help in creating the necessary coding to get these data retrieved and into the form. Of course, I intend that completing this Return form will update the inventory to show that the issued item has been returned to "stock." Currently, the LoanID box is defined as "unbound" with the Record Source as
SELECT tblAssetsLoaned.LoanID, tblAssetsLoaned.AssetID, tblAssetsLoaned.BorrowerID, tblAssetsLoaned.UserIDOut, tblAssetsLoaned.LoanDate, tblAssetsLoaned.DueDate, tblAssetsLoaned.PrimaryLoc, tblAssetsLoaned.SecondaryLoc, tblAssetsLoaned.TertiaryLoc, tblAssetsLoaned.UserIDIn, tblAssetsLoaned.ReturnedDate, tblAssets.OnHand
FROM tblAssets INNER JOIN tblAssetsLoaned ON (tblAssets.TertiaryLoc=tblAssetsLoaned.TertiaryLoc ) AND (tblAssets.=tblAssetsLoaned.SecondaryLoc) AND (tblAssets.PrimaryLoc=tblAssetsLoaned.PrimaryLoc) AND (tblAsset.AssetID=tblAssetsLoaned.AssetID);