Filter listbox by monthname - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Filter listbox by monthname

Ester Grande

3 years ago

Hi I have a listbox containing record of all my payment due date. I can filter the listbox picking a start date and a end date, but I was wondering whether there is a method to select in a combobox a month by monthname (I would like all the months even if there is no record on a certain month) and a year from another combobox (for example the next 5 years) and have all the records of that month and year shown on the listbox.

Can you help?

Thanks

	Juan C Rivera @Reply 3 years ago
sounds like you need just the date part and set up your query criteria Hope this point you in the right direction. V/r Juan

	Kevin Yip @Reply 3 years ago
Use two columns for your combo box: month name and month number. Use month name for display, but use month number as the bound column. Then you can use the combo box's value for your query.

	Kevin Robertson @Reply 3 years ago
I made up a quick (and simple) example of what I think you are trying to do (see screenshot). Give it a go and let us know how you get on.

	Kevin Robertson @Reply 3 years ago

	Kevin Robertson @Reply 3 years ago

	Juan C Rivera @Reply 3 years ago
Wow I like that I'm going to use this exsample. Way to go.

	Ester Grande OP @Reply 3 years ago
Thanks a lot Kevin, I ll try as you suggested

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View