Printable View
I have what I think is a bizarre problem. I have an updown control buddied to a bound textbox. When I type to change the value in the textbox, it updates the DB field just fine. However, when I use the updown control to change the value, it changes the visible value in the box, but does NOT update the field in the DB. This is confusing the he!! out of me. Help?
What textbox event updates the database? Is that event fired when you use the up/down control?
The update event is triggered by another click event of another control. But when I use the updown to change the value in the textbox, it doesn't update the DB. If I type into the textbox to change the value, then it does update.
So you have no code at all in any of the textbox's events?
No, it's a bound control. The only code on the form is the ok(update) and cancel control buttons. The updown is buddied to the textbox.
Can you zip up your project and attach it?
I don't know what good that would do. Everything updates fine, including the textbox, except when the value is changed with the updown control. If I type in the textbox and click OK it updates to the new value. The updown control appears to change the text, but it's not getting through to the recordset. Maybe I should abandon the buddy method and code it.
That way I could run and debug the code myself. BTW, if you are going to give up something I'd suggest the bound control(s).Quote:
Originally posted by DUNSEL
I don't know what good that would do. ....
But the controls update just fine. All the textboxes update the DB except when the updown control is used to change the value in the txtbox. If I type in the change it updates. that's why it's baffling. I should just code the scrolling I think. BTW, I'd be happy to attach the project, but it's on my laptop, which is tough to get online with my setup here. I'll be able to do it tomorrow, if I don't solve it by then, and would appreciate any help.
This has been resolved. Bound controls only update when they have focus. Setting the focus to the textbox, in the change event of the updown control, solved the problem.