If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Speed increase
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 |
#2
|
|||
|
|||
Speed increase
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 "Ben" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|