whoknows361
Technical User
hello all
I have a form which users enter data based on which client they pick from a combo box.
the combo box(combo_client) is in the header so that when a name is picked the detail section shows the correct record, so that users can enter info for this client.
the combo box(combo_client) uses "Referral_ID" (autonumber) to identify which name is chosen.
The same table(tbl_ReferralData) which holds Referral_ID, also holds a field called "Client_Status".
Currently, the user clicks a name and enters data for htat client, which all works fine.. But how do I, when a user adds the info and clicks the button, make the "Client_Status" field automatically change to the text "open" for the selected client(which is chosen in combo_client)?
Regards and appreciation.
I have a form which users enter data based on which client they pick from a combo box.
the combo box(combo_client) is in the header so that when a name is picked the detail section shows the correct record, so that users can enter info for this client.
the combo box(combo_client) uses "Referral_ID" (autonumber) to identify which name is chosen.
The same table(tbl_ReferralData) which holds Referral_ID, also holds a field called "Client_Status".
Currently, the user clicks a name and enters data for htat client, which all works fine.. But how do I, when a user adds the info and clicks the button, make the "Client_Status" field automatically change to the text "open" for the selected client(which is chosen in combo_client)?
Regards and appreciation.