Please be patient. The more I dig into Access, the more confused I get. I did fine on the table design part -- but trying to translate help files and manuals (are they written in Sanskrit?) into practical solutions is proving beyond me in the form design. I will limit myself to one problem per post (but I have lots of problems!).
Problem 1: I have a form called frmNewContacts, which has a subform frmNewFirms. On the underlying tables, tblContacts has a many-to-one relationship with tblFirms, joined by strCompanyID. On frmNewContacts, strCompanyID is bound to a combo box, cboCompanyID. I want the Not_In_List event to (1) add the new company name typed into cboCompanyName to the txtCompanyName field on frmNewFirms; (2) pass control to the txtBusinessStreet text box on the frmNewFirms subform; and (3) after all data entry is complete, return to the main form (frmNewContacts) to include the newly-added company in cboCompanyID.
Please speak slowly and clearly -- I do not understand Sanskrit....
Problem 1: I have a form called frmNewContacts, which has a subform frmNewFirms. On the underlying tables, tblContacts has a many-to-one relationship with tblFirms, joined by strCompanyID. On frmNewContacts, strCompanyID is bound to a combo box, cboCompanyID. I want the Not_In_List event to (1) add the new company name typed into cboCompanyName to the txtCompanyName field on frmNewFirms; (2) pass control to the txtBusinessStreet text box on the frmNewFirms subform; and (3) after all data entry is complete, return to the main form (frmNewContacts) to include the newly-added company in cboCompanyID.
Please speak slowly and clearly -- I do not understand Sanskrit....
