860 pts.
POSTED: Nov 19, 2008 8:28 PM (GMT)
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
Adding new entries to a table via a combo box in a form
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!
Would love some help!
ASKED:
Nov 18, 2008 5:41 PM GMT
UPDATED:
November 19, 2008 8:28:18 PM GMT
RELATED QUESTIONS
- Create a combo box or dialog list to retrieve other combo box values
- Using combo box to populate a sub form which is used to create a new record
- help with access database
- Auto-Populate an Access form using a table of values
- How to retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?
- Issue with a sub procedure and its arguments.
- Getting a syntax error (missing) operator in query exp
- Combo Box Selection Locks Form
- Recursive Association with compound primary key in SQL database
- Master/Child Link problem in Subform
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.
To see other answers submitted to the Answer Wiki View Answer History.
