Combo Search Box

[bladelock]

I used the wizard to create a combo search box on a form which works great. I
have three fields: Fname, Lname, HE#. I'm searching on Fname. How can I get
the the combo box to index the search? For Example: When I type the name
Carl, I would like to see all the "Carl's" in order, this way I can choose
the right person by last name. The data is all scattered, I need to see Fname
in order.

Combo Box: Row Source:
SELECT [MOTHER7].[ID], [MOTHER7].[FNAME], [MOTHER7].[LNAME], [MOTHER7].[HE]
FROM MOTHER7;

 

[Ken Sheridan]

SELECT [MOTHER7].[ID], [MOTHER7].[FNAME], [MOTHER7].[LNAME], [MOTHER7].[HE]
FROM MOTHER7 ORDER BY [MOTHER7].[FNAME];

Ken Sheridan
Stafford, England

 

[Wayne-I-M]

Hi

Use this
SELECT [MOTHER7].[ID], [MOTHER7].[FNAME], [MOTHER7].[LNAME], [MOTHER7].[HE]
FROM [MOTHER7] ORDER BY [FNAME], [LNAME];

Don't forget you can always use the wizard to create a query to run to combo
and you can sort this in any way you want.


Hope this helps

 

[Ofer Cohen]

If you can hide the Id column in the combo box, set the column width of the
ID to 0.
That way the first name will apear as the first column, and the AutoFill
will apply to it