Hi
I want to update table's field based on combo box selection, all table fields are on same form of combo box.
for example if i select employee ID 1 in cboEmpID than all his details and text boxes or combo boxes field on form should change to this employee's information and this information should be editable to take effect in to table.
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.
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.
for example if i select employee ID 1 in cboEmpID than all his details and text boxes or combo boxes field on form should change to this employee's information and this information should be editable to take effect in to table.
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.
i need to figure out how i can do it with all above points, what is that strategy?
Any help will be appreciated.
