Unanswered: Code to print current record on the form
I've created a table with a datefield with "MM/DD/YYYY" format. I've also created a form, query & a report based on the table. I want a form where user can enter Month (name of month in text) and a Year (in digits) and hit a command button to get the specific records falling in the specific month and year.
I've created a query on the Month and Year. But the query asks for month in number and again pops up for year in number. Instead of two pop-up forms i want to create one form for user input. I have tried to create one, with a call to the query. But even after the user input the query pops up for the same information again.