I am using MS Access 2007 under MS Windows 7 Home Premium. I am having a problem with updating a table record in my Lending Library system. I have a multi-form which is based on tblAssets, which contains records of information relating to each asset. This main form uses a combo box for entering an AssetID either by keying in or selecting from a pull-down menu. The row source for this main form selects all fields from tblAssets and specifically uses an embedded macro at After Update to SearchForRecord by AssetID as entered in the combo box. This populates fields in the main form to identify the selected asset, including the OnHand field, in which Yes/No confirms the items availability. This also activates the subform, which is based on tblAssetsLoaned, and brings up a NEW record, which is partially populated with selected fields from tblAssets. When the BorrowerID (from tblBorrower) is keyed into the subform, the NEW record changes to next one available in tblAssetsLoaned and the record is updated. Finally, a button on the main form can be selected to view the checkout document created to complete the transaction. All this works fine, except for one critical detail, which is my problem. The OnHand status of this asset in tblAssets has not been updated to show it is no longer available. I would appreciate help in guiding me to solving my dilemma. How do I make this update happen? I would expect this solution procedure could be reversed via a separate form, when the item is returned, to update tblAssets to OnHand availability again.