Date - Month and year only

[Janjang]

can i change date format that contain day, month, and year to month and year only..
i try change at fromat at porperties, but it change back into dd/mm/yy at combo box..
this is bcoz i want to filter up my subform that contain parts that purchased by customer by month..

thanks..

 

[Newman]

Select Distinct Month(MyDate) & "/" & Year(MyDate) as MyNewDate From MyTable;

 

[Janjang]

can u tell me at where to use this?

 

[Newman]

In the Content property of the combobox.