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...Loo k forward to anyone assistance...Th ank you!
-
-
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!
-
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!Comment
Comment