Query Used to Run Fast, Now It's SLOOOOOW!!

[KellyStee]

I have a form that is based on a query that took 15 different parameters and looked up records based on these 15 different values. It's a pretty simple query and it worked fine and was very fast. The results would display almost instantaneously.
THEN I got a little brave and I tried to make an additional query that was more complex. I added it to the same form and it REALLY slowed down the form. So I took the query out of the form and the form was STILL really slow. So I deleted the query from the database altogether and the form is still so slow. I even tried "Repair and Compact Database" and it's still really slow. What am I doing wrong?

One other thing I did. . .I added indexes to the table that both queries feed off of to help the second query's performance. It didn't really help. So after deleting the second query, I left the indexes on, thinking it couldn't hurt, but my form was still so slow even after deleting the 2nd query. I took the indexes off too, but it's still slow. I feel like I've totally removed anything new I ever added to the database at this point, but the performance is not the same.

Please help!

 

[tracy1234]

Does the query that was used to build the form run slow when it is run outside of the form?

 

[KellyStee]

Thanks for the input Tracy1234. I went back and looked at the main query and it ran really slow too, so I reviewed the code there saw my mistake. Sometimes you just need someone to ask you the simplest question and then you figure it out. . .)