Combo Boxes in forms

  • Thread starter Thread starter RobinF
  • Start date Start date
R

RobinF

What is the best way to use combo boxes so I can choose
from Items in the box, but also to add new items to that
combo box?

Thank You

Robin Finlay
 
If the combo's bound column is not hidden and there is only one value to
add, you can use its NotInList event to add new values. Example:
NotInList: Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

For other cases, consider using the DblClick event of the combo to open the
form where the user can add records to the lookup table. Then in the
AfterUpdate and AfterDelConfirm events of the lookup table's form, requery
the combo so the new entries show up.
 
Back
Top