Scrollbar is zeroing out flowfields

Demonic240 · 2007-10-24

I had an issue a few months back with the scrollbar on a form with a flowfield zeroing it out. I never did find out what was causing it though. Recently I just made a new form and receiving the same error. On form 1 the flowfield is running as a SUM of 2 fields. On form 2 the flowfield is a COUNT for the records being displayed.

What is happening is that when you manually scroll the bar down and then back up to the top of the form the flowfield will display a value of zero. The only way that I know of to fix this is by closing the form and the re-opening it. Has anyone else run into this problem? And if so, how is it fixed?

Savatage · 2007-10-24

Flowfield Count.

Is it a list type looking form?

Usually on these types of forms I simply add a text box at the bottom with SourceExpr = COUNT and it works for me.

Savatage · 2007-10-24

Perhaps this is your Zeroing problem?

FlowFields are virtual fields. The values in these fields are not saved in the table. This means that you must use the CALCFIELDS function to update them. For example, if you retrieve a record using the FIND and NEXT functions, the system sets the FlowFields in those records to zero (0). Then, when you call CALCFIELDS, the system updates their values.

Demonic240 · 2007-10-24

Ah, just had to put a CALCFIELDS in the right place. I put it in the OnAfterGetRecord on the form. Now it doesn't 0 it out. Thanks!

Savatage · 2007-10-24

Just a lucky guess

:-$

Demonic240 · 2007-10-24

Think you could get a lucky guess on my other thread?

Scrollbar is zeroing out flowfields

Comments

Categories