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