Hi, I have a main form that displays a users details. When the edit button is clicked a subform appears which has more info about the user the main form has a control that displays a PolicyNum the subform displays a record from the policy table where [policyNum.policy = policynum.user] however policynum can be edited on the user form which will update the user table but not the policy table or policy subform. How can I implement the change in the subform and the policy table? As you may have guessed I'm pretty new to this.
Any help appreciated.