Code to add entry into Combo Box

  • Thread starter Thread starter forest8
  • Start date Start date
F

forest8

Hello

I have created a combo box that currently has the names of 8 instructors. As
in life, there may be additions to list of instructors.

How do I set up the code that will add new entries to my combo box so that
it will now appear in the list of instructors?

Thank you in advance.
 
Your best bet would be to have a table that includes the list of instructors
and use that as the RowSource of the combo box. You'd then be able to add
(or remove) rows from the table.
 
If your combo box is using a table as its source then you can either create a
form to add new records or you can use the Not In List event to add the item
using vba.

If you are currently using a value list as the source for your combo box you
will need to change your design and use one of the methods listed above.

Here are a few links on the subject:
http://www.databasedev.co.uk/not_in_list.html
http://www.fontstuff.com/access/acctut20.htm
http://www.blueclaw-db.com/access_notinlist_advanced_example.ht
http://www.everythingaccess.com/tutorials.asp?ID=NotInList:-Adding-values-to-lookup-tables
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Back
Top