Hello all:

I am trying to figure out how to run a report based by date. I have a field in my 'Inventory' table named 'Submitted Date'. I would like to fire up combo box the pulls up a calendar and once a date is selected, fire up a report that will list all records from the inputted 'Submitted Date' and beyond.

I created a form which lists the start date and pulls up the calendar.
I need to pass the 'cboStartDate' parameter to my Inventory Report and list the records.

Thanks,
Tony

Just use the WhereCondition argument of the OpenReport command. It will apply a filter.

HTH RuralGuy (RG for short) acXP WinXP Pro

If the date is in the cboStartDate, what you might try is in the Query behind your report, place the following in the Criteria line for the StartDate field:

[Forms]![frmYourFormName].[cboStartDate]

Did that help? Otherwise I can show you how to do this programatically.


mmcdonal