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.
May 11, 2009 3:07 PM
June 25, 2009 3:21 PM