Not In List Event

[ChrisDo11]

not in list

I have a drop down(unbound) on my form(transmittal) which looks up other records on the form(company names). the user selects a company from the drop down to send the transmittal to. All the transmittal info is saved in a table.

I run into problems when i want to send a transmittal to a company that is not in the list.

I'd like to have a pop which allows you to go to the form which adds companys to the list.

I can get this to kind of work by putting a macro in the "on not in list" event which then opens a form or a pop up, but i still get an error message saying something like "the text you entered is not in the list, please enter text or select an option from the list" is there a way to get rid of this?

thanks....

 

[spacepro]

The form needs to be refreshed, for it to see the data.

Hope this helps

Andy

 

[directormac]

Chris:

There's lots of code and info in the forum archives on this, as it's been covered many times. Search for the phrase "notinlist" and you're bound to find the answer.

--Searching Mac

 

[ChrisDo11]

thanks, i can get it working for the most part.... but i still get an access error message "the text you entered isn't an item on the list... select an item from the list or enter text that matches one of the listed items"... is there a way to turn these error messages off? or get rid of them?

 

[Mile-O]

is there a way to turn these error messages off? or get rid of them?

If you don't want the data entered to be allowed:

Response = acDataErrContinue


If you have added the data tha wasn't in the list:

Response = acDataErrAdded


You'll notice that Response is a parameter of the NotInList event.

 

[cheuschober]

Mile-O (or anyone else)...

To expand on error handling further, if one wanted to supress the response altogether, would that be possible? (specifically, if one is opening a modal unbound form to add data not found in the combo...)

Regards,
~Chad