I need some help..

[misdirection]

Ok, I am very annoyed with the parameter value box which requires me to enter a value and it was unintentional and wasn't suppose to happen.

On the main menu, I am trying to generate the report based on the date range, report type, and document type, here's my VB code:

If IsDate([txtFirstDate]) And IsDate([txtEndDate]) Then
recDateCrit = "[txtDateRecieved] >= # " & [txtFirstDate] & "# AND [txtDateRecieved]<=#" & [txtEndDate] & "# AND cmbDocumentType = '" & Me.lstDocType & "'"
DoCmd.OpenReport "rptDateRecieved", acViewPreview, , recDateCrit

It's suppose to work as intented, but I KEEP getting the parameter box popping up for dateRecieved and DocumentTypye. I used the Access Help featured and I went through every steps to get rid of it, and it won't.

What did I do wrong???

 

[georgedwilkinson]

Not sure what you mean by the main menu, but typically Access will ask for the value of a "parameter" when it cannot "see" the control name you thought that you provided to it.

For instance, you have a reference to "txtDateReceived" and you said "from the main menu". Does "main menu" have a control named "txtDateReceived"? If not, that is your problem with that one.

Next you have a reference to "Me.lstDocType". Does "main menu" have a control named "lstDocType" on "it"? If not...

 

[misdirection]

The main menu is where I generate the reports. I have two other forms where the user inputs the information and add it to the record. The main menu form is just to generate the report - so I just want to user to enter the date range, doc type, and the report type --> then I will generate the report. Thanks.

I will double check my object name.

 

[misdirection]

Ok.. I fixed it!

However, it's only showing one report at a time, not mutiple reports. For instance, there could be multiple person with the same document type. How do I resolve that? One to many report? If so, how?

Thanks..

 

[misdirection]

bump

I am still trying to figure out how to make multiple records to show up after I generate a report, not showing just one record, any input would be greatly appreciated.