Combo Box Question

[bill crumpton]

How can I sort the results of a combo box alphabetically? Also how can I filter out certain records in a combo box by populated field. IE Say I want a combo box to show every record in a table that had the date field empty.

Thanks for all your help out there.

 

[Travis]

The recordsource of your Combobox is the same as a query. If you use the query you can for the first part add an Order By on the field that you want alphabatized. For the Second issue add a Where Criteria that the date field Is Null.

 

[bill crumpton]

Thanks Travis......Right on both questions. U The Man.