Hi
I want to update table's field based on combo box selection, all table fields are on same form of combo box.
First when i select combo box text fields and other combo boxes on form should be update/change as per cboEmpID selection and in same if i need to change in any of text field data that should be enabled to accept the changes, so the record in table will be updated based on my changes on text fields.
All control source is from tblEmployee field, cboEmpID is the combo box that will be trigger for all changes in all data fields on form.
It sound little complicated, hence i attached strip version to understand clearly.
i need to figure out how i can do it with all above points, what is that strategy?
Any help will be appreciated.
I want to update table's field based on combo box selection, all table fields are on same form of combo box.
First when i select combo box text fields and other combo boxes on form should be update/change as per cboEmpID selection and in same if i need to change in any of text field data that should be enabled to accept the changes, so the record in table will be updated based on my changes on text fields.
All control source is from tblEmployee field, cboEmpID is the combo box that will be trigger for all changes in all data fields on form.
It sound little complicated, hence i attached strip version to understand clearly.
i need to figure out how i can do it with all above points, what is that strategy?
Any help will be appreciated.