Using VBA (SQL) within an Access Module and referencing the following elements, I would like to execute an Update action by transferring the contents of two text boxes within a form to an Access table where text box txt.ID = "ID" column in target table.
Form Name: frmQualityCheck
Text Boxes: txt.StartDate, contents to be transferred to StartDate field within tblQualityBase where txt.ID = ID field within tblQualityBase
txt.EndDate contents to be transferred to EndDate field within tblQualityBase where txt.ID = ID field within tblQualityBase
Table Name: tblQualitybase
Table Fields: StartDate, EndDate, ID
Thank you in advance for any assistance provided.