Linking Fields in Separate Forms

[MrsGorilla]

Hey,

I know the answer to this one is probably simple, but I can't figure it out and I haven't found any other posts that cover this same problem exactly.

I have two tables, PersonalInfo and PolicyInfo. The primary key in PersonalInfo is SSN, the primary key in PolicyInfo is Policy #. PolicyInfo also has SSN as one of the fields and it is linked to PersonalInfo with a one to many relationship as one person may have more than one (insurance) policy.

Now, I am trying to get users to enter the personal information on a person, then click a button to open up another form where they can enter the policy information for that person. How can I get the SSN field of the Policy Information form to automatically populate with the SSN of the Personal Information form? I can get it to work with an unbound text box, but I am wanting to save the record in the PolicyInfo table with that person's SSN.

Any suggestions? Let me know if I've explained it clearly enough.

Thanks.

 

[catcoota]

Hi

Actually um not sure of the answer coz i havn't tried it yet, but if you join the 2 tables using a query, and then make a form out of this query

In the Create form Wizard, when u select the query, click next and then u will have select by wish table u want to be ordered and then u have to choose one of these - which in ur case should select the second choice (linked forms)

1- making a form with sub form
2- or making linked forms

 

[dcx693]

I think it would be easier to use a single form with personal info in the main part and policy information in the subform.

 

[MrsGorilla]

Thanks for the suggestions, but I figured out another way to do it. I tried the subform first, but couldn't ever get it to work and look like I wanted. Instead I used the unbound control to bring the SSN over, then used VB to set the SSN field once it was on the PolicyInfo form. Why it wouldn't just let me set the SSN to begin with I'm not sure, however.

Thanks!