I have a problem that if fixed will simplify my DB file a lot. I have a form called "CreditFaciility" and when the LastName field on a subform called "subGuarantors" is double clicked I need to open the form "PersonGuarantor". This is working well. When the PersonGuarantor form open the user can enter information as needed. If the user has a new record they are adding the following should happen:
When the Pencil button is pressed, the "PersonBrowser" form should open up. From this form they should be able to Press the "Select" button to select a person or press the "New" button to enter a new person. If Select is pressed the appliable IDs should be entered into the "PersonGuarantor" form.
It does not seem very complicated but because I am a code rookie, I have no idea how to accomplish this.
Any help someone could provide would be GREATLY appreciated.