Creating a New Record

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.
 

Users who are viewing this thread

Back
Top Bottom