Home > IT Answers > Database > Adding new entries to a table via a combo box in a form
Danielgroot
5 pts.
 Adding new entries to a table via a combo box in a form
Access 2003, Access Database, Database issues, Microsoft Access
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!

Software/Hardware used:
ASKED: November 18, 2008  5:41 PM
UPDATED: November 19, 2008  8:28 PM
RELATED QUESTIONS
Answer Wiki:
I think you are just needing to right click the combo box (in design mode) and change the property "Limit to List" to No.
Last Wiki Answer Submitted:  November 19, 2008  6:24 pm  by  tlsanders1   1,240 pts.
All Answer Wiki Contributors:  tlsanders1   1,240 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

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

Randym
 1,740 pts.