Connie,
The first thought that comes to mind is that somewhere there is an extra
space in the Address. What happens when you type in *lot* and then hit the
space and so on... Do yes the list start to narrow down?
Thanks,
Gina Whipp
2010 - 2011 Microsoft MVP (Access)
_www.regina-whipp.com_ (http://www.regina-whipp.com/)
In a message dated 7/18/2011 12:50:40 P.M. Eastern Daylight Time,
no_reply@yahoogroups.com writes:
Forgot to mention that I'm using Access 2007.
--- In _MS_Access_Professionals@yahoogroups.com_
(mailto:MS_Access_Professionals@yahoogroups.com) , mrsgoudge <no_reply@...> wrote:
>
> Good morning!
>
> I have a combo box HomeInfoID. Its control source is HomeInfoID. Its Row
Source is qAddressCity which has three columns: HomeInfoID (bound) and
AddressCity (visible) and ParcelID.
>
> When I type an address such as 7 North Court it works. It initialy shows
7 Circle Pines and as I type the N from North it changes.
>
> When "Lot in East River Hills" is typed it does not find as you type it
even though it is in the drop down list. I get the message "this is not in
the list, do you want to add it?" I have tried using other non numerical
items such as Iowa Ave. and it does not find them either.
>
> I have decompiled, compacted and repaired the database.
>
> Included below is the SQL for qAddressCity.
>
> Also included is the record source for the form (qListings)
>
> Any thoughts?
> Connie
>
> qAddressCity
> SELECT qAddressCity.HomeInfoID, qAddressCity.AddressCity,
HomeInfo.ParcelNbr
> FROM qAddressCity INNER JOIN HomeInfo ON qAddressCity.HomeInfoID =
HomeInfo.HomeInfoID
> ORDER BY qAddressCity.AddressCity;
>
> SELECT DISTINCTROW Listings.ListID, Listings.HomeInfoID,
Listings.PropertyName, Listings.ListDate, Listings.ExpDate, Listings.ListingAgency,
Listings.OriginalListPrice, Listings.CurrentListing, Listings.OccupancyID,
Listings.LockboxNbr, Listings.LotSize, Listings.ZoningID, Listings.HouseTypeID,
Listings.Beds, Listings.baths, Listings.Fullbaths,
Listings.ThreeQuarterBaths, Listings.Partialbaths, Listings.SquareFoot, Listings.Notes,
HomeInfo.ParcelNbr, Listings.TelCombo, Listings.XtraInfo, Listings.YearBuilt,
Listings.Rural
> FROM (HomeInfo INNER JOIN (Listings LEFT JOIN ListingContacts ON
Listings.[ListID] = ListingContacts.[ListID]) ON HomeInfo.HomeInfoID =
Listings.HomeInfoID) LEFT JOIN PotentialListings ON Listings.ListID =
PotentialListings.ListID
> WHERE (((Listings.CurrentListing)=-1)) OR
(((PotentialListings.ListID)=[Listings].[ListID]));
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar