Not In List Event

  • Thread starter Thread starter APG
  • Start date Start date
A

APG

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>
 
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.
 
Is there a place (step) in the code where it stops/errors?

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.
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.
 
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>
 
Thanks

...Figured I'd try the newsgroup as my last resort and then do the dastardly
deed.

Appreciate your input
 
Back
Top