Hello,
Have code in Access Form.
Private Sub NameID_Change()
Dim crit As String
crit = "Select LastScore from Person where PersonID = NameID"
Me.Handicap = crit
End Sub
Trying to update field on form called Handicap with sql statement
From table called Person
Lastscore is in the Person Table
PersonID is in the Person Table
NameID is on the form
Jk
Start Free Trial
