Edward S wrote:
I have a continious form which keeps automatically scrolling down when
it is loaded. This form's control source is a query that has 2 fields
and each is derived from a DSum function
How can I stop this scrolling and just have the data fill into this form
either instantly or atleast gradually fills in but not have atleast 6 to
7 times keeps filling in. This looks very poor to the user.
Appreciate if someone could point me in the right direction
Regards
Ed
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Could you describe scrolling? Let's say you have 200 records. Does it
start at record 1 when the form is opened and then by scrolling it
displays the last few records?
Let's say you have 20 records per viewable screen. When it loads, it
prints/presents a record to the screen so it looks like it ripples?
Like prints each field but enough of a pause between each field the
effect of presenting the records is not instantaneous? That's normal in
calced fields. Open up a query sometime with a calced field. It does
the same thing. The longer a field takes to calc, the more rippling
effect. Now if it ripples several times, it can be caused by multiple
calls of an action in the Activate and Current and Open and Load events.
You could try this. Create another query, make it a TOTALS query, that
contains 3 fields; ID and your two fields that you are summing and group
on ID, sum on the other 2 fields. Now link this to the query used in
the recordsource.