I have created a query that outputs a review date for parts in mm/dd/yyyy format. I would like to create a form that allows the user to enter a month (by name) and filter a report to show all parts that need to be reviewed for that month. Any advice or resources would be appreciated!
Kevin Robertson
@Reply 3 years ago
I would use a Combo Box for the month. The first column (hidden) would be the month number and the second column (visible) would be the month name. You can either store this information in a table or add them dynamically with a For Next Loop. Then use the value of the Combo Box as part of the criteria in your query.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
