Please Help!

[Floyd Forbes]

I have a combo box that is base on a table, on a form.
How do I sort from A-Z in my combo box.

Floyd

 

[Art]

Hi Floyd,
Open the form containing the combo box in design
mode. On the Recordsource property line you should see
some SQL if you used the wizard to build the combo box.
For example:
SELECT [tblTests].[ID], [tblTests].[Number],
[tblTests].[LName] FROM [tblTests]

Add the following to that line:

ORDER BY tblTests.Number;

Change the field names in the above example to the ones in
your db

Hope This Helps

 

[Gerald Stanley]

Change the RowSource to use SQL to something like the following

SELECT {yourColumn} FROM {yourTable} ORDER BY {yourColumn}

You will have to change {yourColumn} and {yourTable}
including {} with your own names.

Hope This Helps
Gerald Stanley MCSD