BlueFlagID AN PK
JobID Number (Long)
JobID AN PK
JobType Number (Long)
DepartmentID Number (Long)
frmJobs is used to populate the tblJObs.
A combo box (cbxJobType) is used to populate the field JobType with a value from the JobTypes table.
Here's what I want to do:
If the user uses frmJobs to change a JobType I want to create a record in tblBlueFlags table that holds the new JobType in JobType2 and the previous JobType in JobType1.
User opens frmJobs and changes the the JobType of JobID 706 from 4 to 6.
This needs to trigger a record in tblBlueFlags
I know how to write the SQL string for inserting the record into the table I am not sure how to get the pre-update value of JobType.