Cancel NotInList event

[Hugh self taught]

Hi O' Clever ones,

I read a discussion here on the forums where Nikos listed a "NotInList"
event using Response = False so I've tried to use it without success.

My scenario is that I need to be able to hide some controls including the
cbo triggering the NotInList & show other controls which includes another cbo
without re-triggering the original NotInList.

Any suggestions?

 

[Hugh self taught]

Hi Marshall,

I couldn't find any other reference to that response so presumed it to be
invalid.

My need is to exit the "notinlist" event without making a valid selection or
adding a new record. The table I'm doing the lookup on is a joined table
where the one source table has the field with data in it & the other doesn't
so in the joined table that field is blank for the 2nd table's records.

Maybe I could make the "NewData" value = blank so that the notinlist can exit?

Using acDataErrAdded or acDataErrContinue still requires a valid selection
from the table.

If the record I look up doesn't exist then I hide those controls & make
other controls visible so I can do a different cbo lookup using other
criteria.

Any options I can try will be appreciated.