Search combo box

[jschlapi]

Hello,
I have a combo box in a form so street names are the same format (Avenue, but not Ave or Road but not Rd). A user will type a home address, then choose the street from the combo box. I'm wondering now if I can put my cursor in the combo box field and search for a specific street. For instance the form always opens to a street called SECOND PLACE - what if I want to find a street called FULLERTON AVENUE.

Each time I try, it always tells me it cannot be found. I've tried all of the following: "Full*", "Fullerton Avenue" and "*Full*"

Any ideas? Thank you,

 

[alansidman]

Maybe something like this: http://www.datapigtechnologies.com/flashfiles/recordsetclone.html

 

[welshgasman]

When I am doing data entry on a new record, the combo is blank. Then as I type, it automatically finds the first matching entry.?
The query for that combo is

SELECT Crew.ID, Trim([surname] & " " & [initials]) AS Name
FROM Crew
ORDER BY Trim([surname] & " " & [initials]);

so the name is sorted alphabetically.