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?

 

[Marshall Barton]

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.

Rsponse = False is not a vaild setting. Look up NotInList
Event is VBA Help for the available settings. It's not
clear from you post that using Response by itself can do
what you want. You may need to use Undo and/or ??

 

[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.

 

[Marshall Barton]

See fow far you can get with something like:

Me.thecombobox.Undo
Response = acDataErrContinue
Me.otherconbo.SetFocus