I have successfully used the NotInList event on several combo boxes to add new records to a table. But I have hit an issue with one.
The new combo box successfully adds an empty record - just the key field populated. But this program does further processing after the NotInList has done its job to get further values for the new record.
So I want to set a flag in the NotInList event to say "add more fields later". But the flag stays unset.
The NotInList code doesn't pause if you set debug and it doesn't set the flag (a global variable).
It is as if this code is on a different level and doesn't access any code around it (but it does add a record to the database)
Weird????