Not In List Question (1 Viewer)

mlopes1

Registered User.
Local time
Today, 11:30
Joined
Sep 4, 2002
Messages
76
Very simple question here! I have added some code under the NotInList event of a combo box. It works fine and the message appears as needed, but after clicking 'OK' to my custom message box, I still receive the default Not in list message box from Access. How do I stop it from popping up and have only my custom message appear?

Thanks as always,

Marco

WinXP/AccXP
 

Agism

Registered User.
Local time
Today, 09:30
Joined
Jun 25, 2001
Messages
44
I am having the same problem.

I have tried adding "DoCmd.SetWarnings False" in every location I can think of and I still get the Access warning.

Has anyone had any success in working around this?
 

Pangloss14

Registered User.
Local time
Today, 15:30
Joined
May 30, 2003
Messages
19
Hi,

I think what you need is Response = acDataErrContinue to suppress the error message.

Hope this helps,

John
 

Agism

Registered User.
Local time
Today, 09:30
Joined
Jun 25, 2001
Messages
44
Yipee!!!!

Thanks John for your help. That is exactly what I needed!!!
 

Users who are viewing this thread

Top Bottom