My question involves three tables, tblAssets, tblITPropertySignOut and tblITPropertySignOutDetails. When an asset is to be checked out by a user the ITPropertySignOut table with the details table as a subform is used and the assets table is linked to the Details table.
My question is this; each asset is assigned to a user and I want the ITPropertySignOut form to automatically assign the asset to the user that is checking it out. Is this a DLookup & Update? and if so can you give me a brief example?
Brian
My question is this; each asset is assigned to a user and I want the ITPropertySignOut form to automatically assign the asset to the user that is checking it out. Is this a DLookup & Update? and if so can you give me a brief example?
Brian
