Little_Man22
Registered User.
- Local time
- Today, 15:31
- Joined
- Jun 23, 2001
- Messages
- 118
Hi...I have a main form (frmClients) that contains a few pages, one of them being a list of all of the client's policies (an embedded subform called frmpolicies). When a policy is converted I have code written that will add a new policy to the list whose status is set to 'new'. However, how can I change the status of the policy that I changed to 'convert'?
As background, to change the policy the user clicks on a command button called Application which brings up a subform where s/he can enter the appropriate information. Upon exiting the subform the user is given the option of saving this information as a new policy (vbYesNo). When the user chooses 'yes' the new policy is created and I'm hoping that this is where the code will be able to be written that changes the current policy's status to 'convert'.
Any ideas?
What I basically need is code that says...
Forms!frmClients!subformPolicies![CURRENT POLICY]!status = "convert"
I don't know what to write for 'current policy' though?
Ryan.
As background, to change the policy the user clicks on a command button called Application which brings up a subform where s/he can enter the appropriate information. Upon exiting the subform the user is given the option of saving this information as a new policy (vbYesNo). When the user chooses 'yes' the new policy is created and I'm hoping that this is where the code will be able to be written that changes the current policy's status to 'convert'.
Any ideas?
What I basically need is code that says...
Forms!frmClients!subformPolicies![CURRENT POLICY]!status = "convert"
I don't know what to write for 'current policy' though?
Ryan.