combo box notinlist event code is on another plane??

[TOPSie]

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????

[Bob Fitz]

Have you tried stepping through the code at runtime to see what is happening?

[TOPSie]

Have you tried stepping through the code at runtime to see what is happening?

It doesn't stop on the brown buttons - the rest of the code does ????

[Bob Fitz]

It doesn't stop on the brown buttons - the rest of the code does ????

The rest of the code does what?

[Bob Fitz]

Do you have [Event Procedure] as the setting for the Not In List event property?

[moke123]

So I want to set a flag in the NotInList event to say "add more fields later".

Why later? Why not have the NIL event launch a form so all the info can be added at once?

[TOPSie]

Ahh the problem is I have several NotInList events for different comboboxes and my old eyes fooled me - I was putting the debug stop on the wrong box - which I didn't access - so all my fault

Thanks for your help - I must try harder in future :-)

[TOPSie]

I am adapting some old code which did all the collection of data an item at a time before writing the new record. My adaption is to constrain the first item requested (the key field) with the combo box. Hence this is now done (NotInList) before the other fields are gathered. if I was starting again I would rethink the whole thing :-)

[Bob Fitz]

Ahh the problem is I have several NotInList events for different comboboxes and my old eyes fooled me - I was putting the debug stop on the wrong box - which I didn't access - so all my fault

Thanks for your help - I must try harder in future :-)

Ha!! I know the feeling