bringing up entered dates

[commanderrico]

Hello,
I have a bunch of records with a date field in the format
MM/DD/YY. What I want to do is create a form in the
program that allows a user to enter a month and a year and
the click a button and the program will generate a report
that shows every record that corresponds with that month
and year. I'm kinda new at this so you'll have to walk me
through most of it if you can. Thanks for your help.

Rico

 

[krameje]

Rico,

On your form, create two text boxes (ie: txtStartDate and txtEndDate). In the record source for your report, use the values input by the user in the two text boxes as date criteria to drive your report. (ie: Between [Forms]![frmMyform]![txtStartDate] And [Forms]![frmMyform]![txtEndDate])

HTH,

JK

Attitudes are contagious