Says: "Enter Parameter Value"
then has my value I actually chose in the search below. Then a white blank. If I type in what i filtered manually it works. If I leave it blank it does not work.
Here is some of the code I have for this particular box. When I "View the Report"
Expand|Select|Wrap|Line Numbers
- Dim Category As String
- Forms!frmReports!cmdCategory.SetFocus
- Category = Forms!frmReports!cmdCategory.Value
- If Category <> "" Then
- whereCond = "Category = " & Forms!frmReports!cmdCategory.Value
- End If
- DoCmd.OpenReport "rptFitNotesSummary", acViewPreview, , whereCond