Hello all,

How can I surpress the message you get when record not found in the Limit to
list from within the Combobox...?
This is not an error message but one built in to Access.

I want to tell the user that they need to enter this custoemr into another
area first before they enter it here ...etc.
--
Andre

One way to go about this would be to set Limit to list = False and do your
own check.

For example, after the user enters info into the combo box, use code in
either the LostFocus or the AfterUpdate event to check the information in the
combo box against the set of values allowed; this should be easy if your
rowsource for the combo box is a table.

If the string value in the combo box is not allowed, then use a MsgBox to
give them a customized error message, and you can automatically clear the
combo box (or not).

HTH,

Nick

--
Message posted via http://www.accessmonster.com

"=?Utf-8?B?QW5kcmU=?=" <(E-Mail Removed)> wrote in
news:A64C982E-C527-424A-A0F0-(E-Mail Removed):

> How can I surpress the message you get when record not found in the
> Limit to list from within the Combobox...?

Look up help for the NotInList event.


Tim F

Use the NotInList event, do whatever suits you, and issue

Response = acDataErrContinue

Andre wrote:
> Hello all,
>
> How can I surpress the message you get when record not found in the Limit to
> list from within the Combobox...?
> This is not an error message but one built in to Access.
>
> I want to tell the user that they need to enter this custoemr into another
> area first before they enter it here ...etc.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
For human replies, replace the queue with a tea

Check out the OnNotInList event in Help, there should be a code example
there that will show you how to handle the error. Let me know if its not
there and I'll post sample code here.

Andre wrote:
> Hello all,
>
> How can I surpress the message you get when record not found in the Limit to
> list from within the Combobox...?
> This is not an error message but one built in to Access.
>
> I want to tell the user that they need to enter this custoemr into another
> area first before they enter it here ...etc.