Question Locked
Autopopulate second combobox based on first combobox
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have two tables
1 - tblAddNewStudy
StudyID
StudyName
StudyDate
PointValue
2 - tblEmployeePoints
EmployeeID
StudyID
PointValue
I have created a form showing Employee ID, Study ID and PointValue from the
tblEmployeePoints.
The form has a combobox for the StudyID field. I want the PointValue field to
autopopulate once the StudyID field has been selected by the user.
I want the PointValue that is autopopulated stored in the tblEmployeePoints
table.
Using Access 2002.
Any suggestions? Thanks