Hi Connie,
put an Index on the combination of these 2 fields in the HomeInfo table design:
click on the lightening bolt icon to open the Indexes window
IndexName = StreetCity (first column -- this can be whatever you want, within reason ;)
- StreetComb
- City
To get an entry in the window, for the Indexes property of StreetComb, in the lower pane, choose --> Yes (duplicates ok)
then, on the next row in the indexes window, in the 2nd column for field, drop the combo and choose --> City
then an index will be built, which will make sorting faster.
Then, in the SQL --> ORDER BY [StreetComb] & [City]
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: mrsgoudge <no_reply@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, May 23, 2012 1:36 PM
Subject: [MS_AccessPros] Re: Filter form box slow
Sorry--the subject should have been "Slow combobox"
--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> Hi all!
>
> I have a form Listings with a combo box HomeInfoID. When I type in the box it usually pauses after two or three characters which is frustrating because you're typing away and most of the typing is for naught and then you need to wait to be able to type the rest. Any input is really appreciate as it's bugging my users (myself included :-(.
>
> The code behind the box has BeforeUpdate, AfterUpdate and NotInList events. Control Source is HomeInfoID. The Row Source is :
> SELECT HomeInfo.HomeInfoID, [StreetComb] & " " & ", " & [City] AS AddressCity, HomeInfo.ParcelNbr
> FROM HomeInfo
> ORDER BY [StreetComb] & " " & ", " & [City];
>
> StreetComb is indexed.
>
> I don't think the following affects the results but just in case:
> There are three comboboxes with HomeInfoID as their control source. The user needs to enter either the address, parcel number or homeid. There is always a homeid but that is impractical for entry. The address is the best way to enter but there is not always an address. Parcel number is the second most practical way to enter but there is not always a parcel number.
>
> Thanks,
> Connie
>
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar