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;

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

Ken Sheridan
Stafford, England

"bladelock" wrote:

> 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;

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

--
Wayne
Manchester, England.



"bladelock" wrote:

> 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;

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


--
Good Luck
BS"D


"bladelock" wrote:

> 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;