Access Too Slow?

  • Thread starter Thread starter Derek Brown
  • Start date Start date
D

Derek Brown

Hi all

I have a subform in a subform on a main form. The query that supplies the
lower level subform gets one of its criteria from a toggle on the same
subform. All works great except when i accidentally scroll the wheel on my
mouse. I then get asked for the criteria that should be supplied by the
subform. Is this the just Access cannot keep up with moving through the main
form at high speed? When I use the page up or down to move through the same
records no problem but the wheel on the mouse causes it to happen every
time?

Any ideas anyone....................Help?
 
Hi Derek

I suspect that the answer is just as you say: Access is too slow. From
experience, I know that the sequence of events between forms and
subforms is bewildering - e.g. subforms actually open _before_ their
parent forms.

So what I think's happening is just that the third subform is trying to
keep up with the rapid movement through records on the main form.

A possible solution would be to leave the third subform unbound to data
(i.e. blank recordsource) and bind it in code

[subform control name].Form.Recordsource="some SQL referencing control
on this form"

Where to put this code is the tricky part. You could
a) leave the third subform unbound unless the user presses a "show more
details" button on the second subform - thus the code would be in the
button's Click, or
b) Do something clever with events on the second subform (meaning the
parent of the third subform). Use the Current and Timer events, set
the Timerinterval to the number of milliseconds you want the form to
wait before deciding "the user is serious about looking at this record,
not just flicking through". On Current, set the form's Timerinterval
to your chosen value (this also resets the timer to 0) and set the
subform's Recordsource back to "". On the Timer event, set the
subform's Recordsource to what you want.

give this a try. Any probs post back to the group.

cheers



Seb
 
Back
Top