Can someone please explain this to me:

As an example I have this form with a spinner and 2 textboxex.

1. spnTerm has as its control source field from table - contract.term
2. txtTerm has the same control source
3. txtResult has as its control source - contract.result

In the InteractiveChange of the spinner, I have the foll code:

Replace contract.result WITH contract.term*2

Now I would expect the value in the contract.result field as well as the contract.term field to change when I change the value in the spnTerm. THIS IT DOES. BUT the values of the two txtBoxes do not refresh and display wrong/old info.

So If I change the value of the spnTerm from 1 to 2 the values in the table change but on screen I still see the old values in the textboxex. When I click on them individually (gotfocus) they refresh, not otherwise though they have their control sources set to fields in the same record.

Weirder still is that if I issue a refresh, the spinner REVERTS to its old value.
So if I change the code in the InteractiveChange of the spinner to:


Replace contract.result WITH contract.term*2
ThisForm.refresh

Then when I change the value of the spinner from say 1 to 2 it changes back to 1 almost immediately. This is because of the Form Refresh.

How else can I make the code in the spinner update the table as well as the textboxes on screen?

Please help as this is very frustrating.

I always thought that when an object was databound to a field changing the object value changed the field and vice versa. This does not seem to be the case....

Bernard