Adding new entries to a table via a combo box in a form

5 pts.
Tags:
Access Database
Database issues
Microsoft Access
Microsoft Access 2003
I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can't add new attendees via that same combo box. I have tried using the event "not on list", but, being pretty new to access, I'm not sure what to do with it. Would love some help!

Answer Wiki

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

I think you are just needing to right click the combo box (in design mode) and change the property “Limit to List” to No.

Discuss This Question: 1  Reply

 
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
  • Randym
    And then if you want to see that new attendee in the combo box without exiting the form, you need to refresh the combo box. Using the OnEnter event of that combo box, put in me!MyCombobox.Requery
    1,740 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