Autopopulate second combobox based on first combobox - TechRepublic
Question
January 2, 2009 at 07:28 PM
katjelko

Autopopulate second combobox based on first combobox

by katjelko . Updated 17 years, 6 months ago

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

This discussion is locked

All Comments