NotOnList event on Combo Box - how to stop pop-up

[Gustavo\]

Hi,

I have a combo box in a form. It has limit to list set to "yes", and
I have declared a NotOnList event procedure to take care of adding a
value not on the list.

Now, my problem is that, even though when I enter a value not on the
list it appropriately opens the form to add a new value, the pop-up
that says "The text you entered isn't an item in the list" still
comes up. This seems pretty unreasonable since I already wrote an
event that takes care of that instance.

So, how can I stop this pop-up from appearing? I tried
doCmd.SetWarnings false, but no deal.

Can anyone help?

Thanks,

Gustavo.

[Trevor Best]

Gustavo) wrote:

Hi,

I have a combo box in a form. It has limit to list set to "yes", and
I have declared a NotOnList event procedure to take care of adding a
value not on the list.

Now, my problem is that, even though when I enter a value not on the
list it appropriately opens the form to add a new value, the pop-up
that says "The text you entered isn't an item in the list" still
comes up. This seems pretty unreasonable since I already wrote an
event that takes care of that instance.

So, how can I stop this pop-up from appearing? I tried
doCmd.SetWarnings false, but no deal.

Can anyone help?

Thanks,

Gustavo.

Something like:
Response = acDataErrContinue ' < sp?
In the event procedure.

--
Pretentious? Moi?

[Hugh Webster]

You have to set the Repsonse parameter of the NotInList procedure. Look in
help for acDataErrAdded.

On 13 Oct 2004 10:42:10 -0700, (Gustavo) <gu******@hotmail.com> wrote:

Hi,

I have a combo box in a form. It has limit to list set to "yes", and
I have declared a NotOnList event procedure to take care of adding a
value not on the list.

Now, my problem is that, even though when I enter a value not on the
list it appropriately opens the form to add a new value, the pop-up
that says "The text you entered isn't an item in the list" still
comes up. This seems pretty unreasonable since I already wrote an
event that takes care of that instance.

So, how can I stop this pop-up from appearing? I tried
doCmd.SetWarnings false, but no deal.

Can anyone help?

Thanks,

Gustavo.

--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/