How to revise the form in MS SQL without reopening

Asked By Adiana 0 points N/A Posted 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.

Thank you.

• Status: Open
• Question Views: 890
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Mahesh Babu 20 points N/A #99356

How to revise the form in MS SQL without reopening

Adiana,

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.

Regards

Mahesh Babu

 

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/27/2011
• Question Category: MS SQL Server