 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / November 2005Not In List Event
Using MS Article ID 197526 August 11,2005, to add a record to a combo box that has not in list event. The event updates the table, but does not allow the item to refresh the combo box. It appears the "Response = acDataErrAdded" function is not being used. Any suggestions? Have you inserted a breakpoint in your code to ensure that the acDataErrAdded is being fired? Jeff Boyce <Office/Access MVP> > Using MS Article ID 197526 August 11,2005, to add a record to a combo > box that has not in list event. The event updates the table, but does not > allow the item to refresh the combo box. It appears the "Response = > acDataErrAdded" function is not being used. > > Any suggestions? At the breakpoint inserted after the response line, the response is two (2). On the acDataErrContinue brealit is one so I am believing that it is firing. > Have you inserted a breakpoint in your code to ensure that the > acDataErrAdded is being fired? [quoted text clipped - 8 lines] >> >> Any suggestions? Is there a place (step) in the code where it stops/errors? Jeff Boyce <Office/Access MVP> > At the breakpoint inserted after the response line, the response is two > (2). On the acDataErrContinue brealit is one so I am believing that it is [quoted text clipped - 12 lines] >>> >>> Any suggestions? Unfortunately no. The code runs, adds the record to the table, returns to the combo box, and immediately indicates that the item is not in the list. When you attempt to reenter or enter the number again, the code fires, prompts for the input again. Entering the same number again at the prompt results in a "this item already exists", yet it is not in the combo box list. As a workaround, I have tried various refresh, requery, routines that I found but none has been successful thus far. > Is there a place (step) in the code where it stops/errors? > [quoted text clipped - 17 lines] >>>> >>>> Any suggestions? I'm not familiar with other potential causes, although a Google search on the topic might reveal some. As a "get it done now" alternative, have you tried backing up your work, throwing out the bum and building a new one? (I use this approach when I run out of time/patience.) Regards & Good luck! Jeff Boyce <Office/Access MVP> > Unfortunately no. The code runs, adds the record to the table, returns to > the combo box, and immediately indicates that the item is not in the list. [quoted text clipped - 25 lines] >>>>> >>>>> Any suggestions? Thanks ..Figured I'd try the newsgroup as my last resort and then do the dastardly deed. Appreciate your input > I'm not familiar with other potential causes, although a Google search on > the topic might reveal some. [quoted text clipped - 37 lines] >>>>>> >>>>>> Any suggestions? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.