Home > IT Answers > Database > Updating Combobox after new data added
SteIT
15 pts.
 Updating Combobox after new data added
Access 2003, Access 2003 forms, Access forms, ComboBox, Microsoft Access
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.

Software/Hardware used:
ASKED: May 11, 2009  3:07 PM
UPDATED: June 25, 2009  3:21 PM
RELATED QUESTIONS
Answer Wiki:
which language you are using? are you looking for concept or code
Last Wiki Answer Submitted:  May 11, 2009  5:01 pm  by  Abhi Here   20 pts.
All Answer Wiki Contributors:  Abhi Here   20 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

vba, I am familiar with this.

SteIT
 15 pts.
 

You need to refresh
cboContacts.rowsource property after entering of new contact.

msi77
 1,610 pts.
 

I know in Access 2007 on the Home tab there is a Refresh All button. Another option is to save, close, and re-open the database.

RandomSkratch
 25 pts.