Home > IT Answers > Database > Access, Searchable Combo Box within a Form?
Accote
15 pts.
 Access, Searchable Combo Box within a Form?
Database, Microsoft Access, MS Access
Hello, I'm trying to create a combo list box in an access form that has all 12 months (January, February......etc,) listed and depending on the selection will bring up only that particular month within a range of dates. I don't want it to look at the day or the year, but only the month. Example: I select January from the drop down list and my form will only display all records with dates that are in January regardless of month or year. Any help with this would be greatly appreciated. Thanks

Software/Hardware used:
MS Access 2007
ASKED: May 25, 2012  4:48 PM
UPDATED: May 25, 2012  8:16 PM
RELATED QUESTIONS
Answer Wiki:
After they pick the month(es) take the results and open a new form and change the filter on the open based on what they picked.
Last Wiki Answer Submitted:  May 25, 2012  7:58 pm  by  orangehat   1,445 pts.
All Answer Wiki Contributors:  orangehat   1,445 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The problem is that I don’t know how to associate the “January” with the 01/**/**** in the date, and to tell it to only search for the 01 part of the date and nothin else.

Accote
 15 pts.