Record lookup with combo box

[Mike Auer]

Hello
I have a combo box on my form that lists the values of a date field. It is an unbound control that I set up with the wizard to search for certain records in the table from that date. It works except for two problems: 1). The dates in the combo box are not in chronological order, they are in what appears to be a random order. The table is sorted by this date and when the form opens, the first record is the oldest record and they are in chronological order. 2). Is it possible to list the date only once in the combo box even if there are multiple records for that date? Thanks!
Mike

 

[jfgambit]

Change the Row Souse of the combobox to be:

SELECT DISTINCTROW [tblNameofTable].[Date] FROM tblNameofTable GROUP BY [tblNameofTable].[Date] ORDER BY [tblNameofTalbe].[Date];

Change my default names to the names of the tables and fields

 

[Mike Auer]

Absolutely perfect, jfgambit!
Thanks a million!
Mike