NotInList Event Programming

[OfficeDev18 via AccessMonster.com]

Could someone please post the proper syntax to use to program the NotInList
event? I want to be able to detect the condition, and to control the addition
of a new record to the table.

Thanx,

Sam

 

[Allen Browne]

See:
NotInList: Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

Note that the NewData you are typing into the list box must go into the
bound field for this to work, so if you have the bound column set to
zero-width you will need to use another approach (such as using the DblClick
event of the combo to open the form where the new entry is made, and then
using the AfterUpdate event of the entry form to Requery the combo.)

 

[OfficeDev18 via AccessMonster.com]

Thanks. It'll take a while to absorb, but I have it all printed out.

Sam