Not in List Event in a combo box.

[Guest]

I recently became a member of a small community savings group. I am
developing a database for entering payments made into the savings group by
the members. This has always been done using a spreadsheet in the past.
Unfortunately when a copy of each days payments has been printed the spread
sheet is closed down without saving.

Each name is to have a 4 digit membership number beginning with 2. I have a
table holding the numbers and names. I have a collection table/form to store
the payment details. I have a combo box on the form listing the members
numbers. I want to use the Not in List event so that New members names and
numbers can be saved from within the collection form.

However, exisitng members have got into the habit of just providing the last
3 digits of their membership number and, because several members are
authorised to enter the details I want to write code so that whenever the 3
digits are entered in the combo box, the number is automatically formatted
to 4 digits and checked to see if it is a new number or not, before the Not
In List event comes into action.

Can any body please help.

 

[Arvin Meyer [MVP]]

Some generic NotInList event code, with how to use it is at my website:

http://www.datastrat.com/Code/NotInListCode.txt