The Text you entered isn't an item on the list, when it is message
Posted on 2009-06-26
During a sequence of adding records on the fly, after I try to close out of the second level of entry I get a message telling me that the text I have entered is not an item on the list. I have tried checking references and shutting off allow auto correct, and changing the Response = acDataErrContinue settings, all to no avail. I believe it has something to do with data types but I can't seem to figure it out. Here is the sequence:
1. From a main form, I want to enter text into a field called Topic via a combo box; if my topic is not there, I use the not in list event to add one on the fly.
2. This opens a form called Add Topics, into which I enter the new topic name.
3. Each topic needs a job number, so I look that up with a combo box, and use the not-in-list event to add new job numbers on the fly.
4. Each new job number needs to be associated with a client, so I likewise select the client name from a combo box, and add new clients on the fly using the not-in-list function.
Every thing works except in step 3 above, after I have successfully entered the job number and either selected existing clients or added new clients I get the "the test you entered is not...." message. When I go back and check the tables, the data is in there, but my workflow is a train wreck? Any ideas for starters? I can add code in the next go 'round. Thanks