Shaky subforms

I

Ivor Williams

I have a products table in which one field is used to rate the quality of
the products as good, better or best. I've created 3 queries from this
table, using the ratings to filter each one. Each of these queries is used
as a record source for a subform. All 3 subforms are displayed on a single
form which is linked to a quote form. Everything seems to work fine except
if I have 2 or 3 of the subforms on the main form at the same time, the
subforms get the "shakes", the mouse behaves eratically with the hourglass
flashing on and off, and if the cursor is put in any field except the first
one in the tab sequence, it will "jump back" to the first field. If only one
of the subforms is included, everything settles down.
I've run the forms on two different computers, both P4's and the results are
the same. It almost seems as if something in the background is looping
through some code.Maybe the problem is because all three subforms are
accessing the same table at the same time? Is there a way I can accomplish
the same thing without using 3 queries? I'd rather not just use one subform
unless necessary.

Ivor
 
Top