By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,644 Members | 2,082 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,644 IT Pros & Developers. It's quick & easy.

Field Properties-Combo Box/Value List/Lookup

P: 18
Hello! I am a beginner with MS Access 2007. Creating a complex DB and need assistance on lookup columns created through Lookup Wizard with Allow Edits in table field. When a user enters a new value not listed in the lookup value list, will that value automatically be added to the lookup list or do I need to manually enter in the Field Property under Row Source? I have many more questions I will post separatly...Look forward to anyone assistance...Thank you!
May 18 '10 #1
Share this Question
Share on Google+
2 Replies


Jim Doherty
Expert 100+
P: 897
@Otter7
Welcome to Bytes :-)
Combos have a 'NotInList' event that responds to when you have 'LimitToList' property set to 'Yes' for the combo concerned. Look in the list of properties in the dialog box for that. The idea then is that you could call the 'NotInList' events sub routine to 'add' an item to an underlying lookup table for you. Below is but one example of this on this site ...search on site and you will find many more!

http://bytes.com/topic/access/answer...multiple-forms
May 19 '10 #2

P: 18
Wow! Went to the link and code language is too advanced for this beginner; will mark for future reference. However, thank you for the insight and clarification on NotInList event; nothing I have studied so far has not mentioned this term/event. Understand how it works now. Note: I tried UtterAccess for assistance but Bytes is easier, faster and I get my question answered with resources!!! Thanks Again!
May 19 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.