before I used Dlookup function it can but the problem is only first record can add it if you check my code
Private Sub Command9_Click()
Me.ID.Value = DLookup("Result", "tblTestResults", "Resut= 'ID' ")
Me.Jame.Value = DLookup("Result", "tblTestResults", "Name= 'Jame' ")
Me.Adam.Value =...