Updating Combobox after new data added

15 pts.
Tags:
Access 2003 forms
ComboBox
Microsoft Access
Microsoft Access 2003
Microsoft Access forms
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

which language you are using?
are you looking for concept or code

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SteIT
    vba, I am familiar with this.
    15 pointsBadges:
    report
  • msi77
    You need to refresh cboContacts.rowsource property after entering of new contact.
    1,660 pointsBadges:
    report
  • RandomSkratch
    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.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following