As always I recommend checking my syntax as it is really perfect.
This is funny, my grammar can be pretty poor as well. This should have said "rarely perfect".
The problem is when the query returns no records, it does not pass the parameter entered to the report so the title just contains an error. I need to title to contain the paramater the user entered regardless of whether the query returns any records. Is there a way to do this without extensive code?
I am not clear on this. I assume that the date entered field is being pulled directly from the forms text box where the date is entered. Your query shouldn't have anything to do with this????
If you wanted to put this in the code I provided change:
Code:
Me!lstDisplayQryResults.RowSource = " No Records to Display"
To....
Code:
Me!lstDisplayQryResults.RowSource = " No Records to Display for " & Me.YourDateTextBoxName