ACCESS FEED: [MS_AccessPros] Slow combo box find as you type

Senin, 30 April 2012

[MS_AccessPros] Slow combo box find as you type

Hi all!

I have a form Listings where the first thing to be entered is the address via a combobox whose row source is a query that draws data from the HomeInfo table. My problem is that entry is increasingly slower. I type in 2 or 3 characters and then have to wait before I can type any other characters. An example would be typing in 55738 210th St Alberta and after 55738 it stops. Access says it is calculating, then says it's doing a query. Have to wait several seconds before I can continue entering. I have tried entering the above several times and sometimes there's no problem and other times there is.

ControlSource: HomeInfoID

RowSource: SELECT qAddressCity.HomeInfoID, qAddressCity.AddressCity, qAddressCity.ParcelNbr FROM qAddressCity ORDER BY qAddressCity.AddressCity;

On Not In List Event:

'If this property has not been entered yet, open the form for entering. (Not using properties feature for this because I can not click on the close button on the form.)
Dim msg, style, title
msg = "This property is not in the database. Would you like to add it?"
style = vbYesNo
title = "Add Property"
Response = Msgbox(msg, style, title)
If Response = vbYes Then
DoCmd.OpenForm "HomeInfo", , , , acFormAdd
End If

I also have a BeforeUpdate and AfterUpdate event, but those are not being triggered since I'm just typing and not tabbing or pressing Enter.

HomeInfo table fields:
HomeInfoID
Nbr
Direction1
StreetID
Direction2
CityID
TownshipID
CountyID
Notes

Thanks!
Connie