Thank you everybody for the great advice! I'm still a bit confused. I have 2 forms now, one form for the company and 1 form for the contact. The Contact form is set as a subform in the Company form. I have an unbound combo box that serves as a record selector with this code:
Code:
SELECT tbl_Company.Company_ID, tbl_Contact_Company.ID, tbl3_Contact_NEW.Firstname & " " & tbl3_Contact_NEW.LastName & " (" & tbl_Company.Company & ")" AS Contact
FROM (tbl_Contact_Company INNER JOIN tbl3_Contact_NEW ON tbl_Contact_Company.Contact_ID = tbl3_Contact_NEW.Contact_ID) INNER JOIN tbl_Company ON tbl_Contact_Company.Company_ID = tbl_Company.Company_ID;
The selector box works great. I can select a Company and see each contact in the subform. I'm still having some issues trying to add a new contact. I know that I can write some code to add the contact to the tbl_Contact_Company table but I was hoping not to write a ton of code to just add a contact. I would appreciate any other suggestions people have. Thank you again!!