Updated record not displayed until mouse pointer is positioned over

[thefox56]

I have a form based on a query for filtering, setting values, and formatting reasons. When the user double clicks the product ID field, a qty field is enabled for the user to enter a transaction qty. There is a command button on the form that updates the onhand qty in the underlying table using VB in the OnClick property of the command button. It also adds a detail record in a related table, then sets the focus at the product ID field on the form.

The problem is that the updated value of the onhand qty is not displayed in the body of the form until I move the mouse pointer over the product ID field. I have tried Requery, refresh, recalc, repaint and nothing shows me the updated value until the mouse pointer is moved over the product ID field. How do I get the updated value to display without having to do this or how to I do it through code?

 

[dan9991]

if you look at the properties you may have code under mouse move on that field, try deleting and putting on a command button

 

[dan9991]

You can also write a macro to do refresh then set it to run like on load or when you need to .