>>I have a menu which repeats the command buttons on a form. One of them is Save. The command on the menu is _screen.activeform.cmdsave.click(). The click event runs code very similar to that found in the Wizbtns class of the screen wizard. When we hit Wizbtns.UpdateRows() basically a TableUpdate() is performed. If I choose Save from the menu, not only is the TableUpdate not performed correctly, but the changes are reverted. If I step through the code, the update IS performed correctly.
>>
>>I have done some Debugout() in the UpdateRows method and found something very odd...
>>
>>When the click() is fired by the menu, OLDVAL(Field, Table) and Table.Field will return exactly the same thing (the old value), even though the Table.Field value has been changed on the form. But they return different (correct) values when fired by clicking on the command button.
>>
>>I'm using optimistic table buffering, but, just for grins, I changed it to NO buffering and the same thing happens!!
>>
>>What's going on here? Any ideas? I'm stumped.
>>
>>Thanks.
>
>
>Calling the click method from a menu does not allow the button whose click method you are calling get the focus. Could that be what is causing the problem? Could you have some other code in place on the button that is run when it receives focus?


No. I didn't have any code in the GotFocus(). But, enlightened by your suggestion, I created a form method m_add and in that method did:

Thisform.wizbtns.cmdadd.setfocus()
Thisform.wizbtns.cmdadd.click()

And IT WORKED! BTW, without the setfocus() it does not work.

Strange work around, but ya gotta do what ya gotta do!

Thanks Brett.