Problem with error routines

[David Smith]

Presently I am using Ms-Access and designing a form using simple combo box

control by setting LimitToList property to Yes. and I added a event

procedure on NotInList to display a Proper Message to the user. When I run

the form and enter some dummy text, it displays the message that I wrote in

NotInList event of combo box along with the standard Ms-Access Message

which I don't want to

display. Please tell me how should i do it.

 

[Allen Browne]

To suppress the built-in message, set the Reponse argument to
acDataErrAdded.

 

[glenn]

Thank You, I have been pondering this issue for some
time. Some standard Access messages are not that
informative to application users.
However I'm light on when it comes to knowledge of the
acDataErrAdded argument. "Please explain", an example
maybe

glenn

 

[Allen Browne]

There is an example in article:
NotInList: Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

 

[glenn]

THANK YOU!

-----Original Message-----
There is an example in article:
NotInList: Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.