Speed increase

B

Ben

Hi,

In a previous reply (Speed Increase - posted early June) I got the
suggestion to limit my queries to current record or a smaller set of records.
What is the easiest way to do this?

I have a form with subforms that is causing a problem as it seems to go
throught the entire DB to search for info, when it does a refresh on
AfterUpdate.

Thanks for your help.

Ben
 
J

Jackie L

I believe they probably meant to put an unbound field on your form and to
base a query off of that field. For instance, you pick a value from a drop
down on an unbound field and then on the After Update event of the combo box
you have the form requery so that the only record you get is the one selected
in the drop down.

Sorry for the general terms. We can be more specific with more info.

Jackie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increasing access speed over network 1
Access speed very slow on forms 4
slow speed on network 8
Tabbed Forms 4
Autopopulate text box based on an unbound combo box 4
Copy record into same table 1
Increasing the loadup speed 3
Creating Unique Front End 1

Top