N/APosted on - 11/01/2011
Some fields in a form at MS SQL Server are obtaining values after calculating the form in a default value method e.g. DBLookup.
In this method the values are only getting revised during reopening of the form.
Would appreciate if anyone tell me the way to revise the form without reopen.
How to revise the form in MS SQL without reopening
You should check how you have set the query for updating fields in the calculating form, maybe you have declared the query such that the values should be revised each time you reopen the form and so you should check that from the datasheet view of the query and change it if necessary.
Otherwise, I will refer you to this site that gives you possible reasons why you may be receiving such kind of error and possible resolutions mechanisms that you may use to counter the error:
The site also suggests that the problem may be caused with the query but just have a look at it for detailed explanation.
Hope this helps.