Subform caused performance delays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I recently added a subquery to a form on my dbs. While the subquery is
selecting the exact data I wanted, the form has slowed down considerably. It
now takes 20-30 seconds to scroll between records in the form. Before using
the subform/query, I just had a command button the user could select to run
the query, but I wanted to just have the subform automatically display the
data for each record. Why did the subform impact performance? How can I
improve?

Thanks !!!
 
I thought I would add that the subquery is selecting criterion from the main
form. So the user opens the main form and a ticket is displayed (ticket
number and store number create the unique index). Those two fields (ticket
and store) are used to retrieve the subform info as well. Why is it taking
so long? =) thanks for your help!
 
if you were using Access Data Projects, then you would NEVER have
performance problems.

MDB is obsolete and for babies.

-Aaron
ADP Nationalist
 
Sorry all - I got this one after a few more tries - I needed to index the
table the subform's query was pulling from.
thanks !
 
FergusonH said:
Sorry all - I got this one after a few more tries - I needed to index the
table the subform's query was pulling from.
Click to expand...

That was going to be my first suggestion. Glad to read you figured it
out yourself.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top