Not in list where cbo is null ie. tab through

[Hugh self taught]

Hi knowledgeable gurus,

I have made use of "not in list" but in this instance I know that the record
doesn't exist & as such I want to just tab through but invoke the "Not in
List" sub. Can I do that in a before update without duplicating the whole
code? What should I be doing as I don't want to add extra buttons etc

 

[ruralguy via AccessMonster.com]

You can just call the NotInList code directly with CALL Yourcbo_NotInList but
I would lean toward executing a similar but different procedure. You can not
pass the Response variable to the procedure so the code will almost certainly
be different.

 

[ruralguy via AccessMonster.com]

Just post back here if you need additional assistance with this issue.

Hi Allan,

I've never used a CALL yet but I'll give it a try. It may work for me. My
scenario is that I have couples who are registered & have a number assigned
for the year. New couples compete but don't have a number yet so they are the
"Not In List". At this stage I still need to record their results so they
still get recorded. It's all done from fields on forms so with hidden text
boxes etc I work around manipulating the data to get it where I need it.

You can just call the NotInList code directly with CALL Yourcbo_NotInList but
I would lean toward executing a similar but different procedure. You can not

[quoted text clipped - 7 lines]