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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit to List 1
How can I add an extra name to a drop down list ? 2
NotInList 1
Not in list event 12
Limit to list and default for combobox 2
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Limit to List - Combo Box 1
NotInList 3

Back
Top