Hi All..
I have a database that store certain of records & i have created a form to search for certain data in the database. In my database i have DOB field to store date of birth. From my search form i would like to select the details of person that fall for the value i will enter in my unbound text/combobox. In this unbound text/combo box which i call Month will filter the DOB that fall in the required month and the result will be displayed in the subform within the Search form. Since i'm using access 2007, i use a query for my source of database in the search form. but it did't return the desired result. I can't use my database since it doesn't contain the field for month... i use query to obtain value for month from DOB field.
can anybody please help me with this... i'm not actually a programmer but i really need to settle this matter. pls refer to the attachment for the database. thanks in advance
annie