Please Help!

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

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
 
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
 
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
 
Back
Top