Using access 2003, I have a form (frmJobSheet) which contains a combobox (cboContacts) containing all the contacts in a talbe (tblContacts). If a name is entered in cboContacts which doesn't exist in tblContacts, I want to open another form (frmContacts) which the user would then enter the new contact details. When frmContacts is closed, I want to return to frmJobsheet and have cboContacts populated with the newly added contact.
I can use Not In List event to open the frmContacts, but cannot then pass the contacts name to the cboContacts on frmJobSheet.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!