View Full Version : Combo Box Question


bill crumpton
09-21-2000, 05:43 AM
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
09-21-2000, 07:08 AM
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
09-21-2000, 09:41 AM
Thanks Travis......Right on both questions. U The Man.