Originally Posted by
ItsMe
When this symptom occurs, it is likely due to performance.
As ItsMe suggested, when things run when stepping through code, but not when running 'normally,' it's usually a performance problem, aka a timing problem. But what does the value selected in Combo32 have to due with [ConfCode] or TxtConstitCode??? It is most unusual for the value of any Control to be assigned by the AfterUpdate event of a Control if that Control isn't directly involved!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007