By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,519 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 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
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 on site and you will find many more!
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.