Access, Searchable Combo Box within a Form?

15 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Accote
    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.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following