Adding to a 'limit to list'

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

Guest

Access2003 on XP
I an entering data via a form that has a combo box set to 'limit to list'
If I have to add to this list can I do it "on the fly". or do I have to exit
the form, add to tblList, reenter the form and continue.
 
If the bound column of the combo is not zero-width (i.e. the value actually
being typed in is the value being used) and there are no other fields that
must be added to the lookup table, you can use this technique:
NotInList: Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

For other cases, use the DblClick event of the combo to OpenForm where the
user can type in the value. Then in the AfterUpdate event procedure of that
form, Requery the combo so the new value shows up.
 
Back
Top