Access 2002 OnNotInList event help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

deanziegler

Thread Starter
Joined
Mar 16, 2004
Messages
16
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!
 
Joined
Aug 21, 2003
Messages
2,016
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

Thread Starter
Joined
Mar 16, 2004
Messages
16
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!
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top