NotInList(NewData As String, Response As Integer)

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

What values and meaning does "Response" take in X_NotInList(NewData As
String, Response As Integer)

and how do you find out?


many thanks in advance

Rod
 
Hi,


===========
Response The setting indicates how the NotInList event was handled. The
Response argument can be one of the following intrinsic constants:

Constant Description

acDataErrDisplay (Default) Displays the default message to the user. You can
use this when you don't want to allow the user to add a new value to the
combo box list.

acDataErrContinue Doesn't display the default message to the user. You can
use this when you want to display a custom message to the user. For example,
the event procedure could display a custom dialog box asking if the user
wanted to save the new entry. If the response is Yes, the event procedure
would add the new entry to the list and set the Response argument to
acDataErrAdded. If the response is No, the event procedure would set the
Response argument to acDataErrContinue.

acDataErrAdded Doesn't display a message to the user but enables you to add
the entry to the combo box list in the NotInList event procedure. After the
entry is added, Microsoft Access updates the list by requerying the combo
box. Microsoft Access then rechecks the string against the combo box list,
and saves the value in the NewData argument in the field the combo box is
bound to. If the string is not in the list, then Microsoft Access displays
an error message.

=============



Hoping it may help,

Vanderghast, Access MVP
 
thanks, this is just what I need, but where do you look it up, it is not in
help as far as I can see.

thanks again
rod
 
Hi,


It is in the help of Access 2003 (it is where I got it) ... and in
Access 97's one
:-)

... and in Google, now.


Vanderghast, Access MVP
 
Dear Rod:

Are you using Access 2002 (XP)? Your post twigged my memory of fighting with
the Help system in my copy of Access 2002, looking for just this
information. I think I ended up getting help from the newsgroups or my
library of Access books, or possibly the help files in Access 97, but *not*
from Access 2002!

So, I thought, well, let's try it again and see if I can find it... After
trying for a looong time, I can't either. I would love someone to prove me
wrong, but as far as I can tell, there is no "help" in the Help system of
*Access 2002*, on the topic of the use of "Response as Integer" or the
intrinsic constants such as "acDataErr...".

You have my empathy...
Fred Boer

I tried again, this morning, to use the Access 2002 Help system to find this
information...
 
Correct, I am using XP. I am glad you can't find it, I don't feel quite so
stupid now!!!

many thanks
 
Back
Top