Combo boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I use an existing combo box to add new data. When I set limit to list
to no
it tells me my bound field and field lengths must change. Any help Please?

Kathy
 
If the combo's bound column is hidden (zero-width), trying to use its
NotInList event to add the new data won't work very well.

Consider using the DblClick event of the combo to open the other form where
the user can enter the data. Then in the Afterupdate event of the other
form, Requery the combo so it hears about the new data.

If the bound column is visible and is the only column where the data needs
to be added, see:
NotInList: Adding values to lookup tables
at:
http://members.iinet.net.au/~allenbrowne/ser-27.html
 
Back
Top