Hi all
strange one I know I have a form with the following fields
CMbStaffName -Picks up from QRYAllAthorisedStaff
CmbDepartment
CmbArea
When the staff name is chosen I want it to input the last entered department and Area for that staff member to be saved so when the same staff member is selected it shows it, but doesn't change the previous records, but if the user needs to change the department they can, I thought maybe I could do an after update on the CMBDepartment field to update the column but no luck any suggestions?
strange one I know I have a form with the following fields
CMbStaffName -Picks up from QRYAllAthorisedStaff
CmbDepartment
CmbArea
When the staff name is chosen I want it to input the last entered department and Area for that staff member to be saved so when the same staff member is selected it shows it, but doesn't change the previous records, but if the user needs to change the department they can, I thought maybe I could do an after update on the CMBDepartment field to update the column but no luck any suggestions?
Code:
Me.CMbStaffName.[Column](4).Value = Me.CmbDepartment.[Column](1)