|
Subject:
|
Lookup Field for Report
|
|
Posted By:
|
eusanpe
|
Post Date:
|
3/8/2007 12:33:04 PM
|
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
|
|
Reply By:
|
RuralGuy
|
Reply Date:
|
3/8/2007 2:23:54 PM
|
Just use the WhereCondition argument of the OpenReport command. It will apply a filter.
HTH RuralGuy (RG for short) acXP WinXP Pro
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
3/9/2007 7:38:24 AM
|
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
|
