Combo box - not in list - cancel normal error msg

[MikiH]

Hi All

I've got a combo box where I'm selecting a suppliers name and storing the supplier-number in the table.

I've got the combo set to "limit to list" and the headings are

supplier number; supplier name
width 0; width 4

when I enter a suppliers name that isn't in the list I run code to open the suppliers form.

I also get the standard warning " the item you entered isn't in the list, select an item from the list"

how do i stop this without turning the warnings off? I've got error handling in the code but this is not triggered as I'm in the not in list event.


Any idea

Thanks
Mick

 

[RoyVidar]

Enter the line:

[tt]response=acdataerrcontinue[/tt]

within the not in list event

Roy-Vidar

 

[PHV]

Add this in your NotInList event procedure code:
Response = acDataErrAdded

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MikiH]

Thanks for the fast response on this I used

response=acdataerrcontinue


worked great thanks