How to revise the form in MS SQL without reopening

Asked By 0 points N/A Posted on -

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.

Thank you.

Answered By 20 points N/A #99356

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.


Mahesh Babu


Login/Register to Answer

Related Questions