Access 2002 OnNotInList event help

[deanziegler]

Working with a combo box in a subform. If data is entered into that box that is NotInTheList i want the AfterUpdate event for procedure to change. T

The If statement in the AfterUpdate should be fairly easy but how do I capture the triggered OnNotInList Event so i can pass it on to AfterUpdate Event , tell it that the NotInLIst Event occured and code it accordingly. Thanks!

 

[MustBNuts]

Okay, question: why would you want a user to be able to enter a value into a combobox that is not a predetermined value? The whole idea for combo is that you are forcing the user to use only those values that you have determined are valid....?

Some will argue otherwise, but even for items as seemingly insignificant as "Mr., Mrs., Miss", etc., combo boxes ensure that repeated data is consistently uniform. This may then require you to create a new, small table to accomodate the values, as well as an option for user to input new value, but it ensures that when you go to create a query, you don't miss data that otherwise should be included because of inconsistencies and/or typos.

MBN

 

[deanziegler]

the reason for wanting to do this is its a "part" entering subform in an invoice form/ Not only did i wish to look up parts by number and/ or description but also be able to "hard code" a part into the invoice that is not in the DB and might just be used for a one time only scenerio or the part iteslf dosent even warrant being added to the DB (a consumable). the problem came when the part was NOT IN THE LIST. My code was filling other fields designated to receive data with null/blanks because a part was not found. I got around this by setting the NotIn List event to yes and when it triggered i used code in that event to accept the "New Data" ,to bypass the AfterUpdate event "pull data code", and to setfocus to the next field. It works fine now Thanks for your reply!