Unanswered: Moving a record upon combo box selection...!!!
A company has offices at different states & they want to track their employees and user has to select the reasons from a combobox list.
cboReason has following options:
Migrated to other state
So, I want that, when a user selects 3rd reason (Migrated to other state), that employee record should have to be moved into the migrated state.
in these tables, each State has different offices & different employees in those offices.
So, when a user selects a "migrated to other state", I want to show another combo box which will show, "Migrated To: " & then when a user selects a State from that combo box list, the said employee should move to that State.
And, next time it should only reflect in the migrated state.