Linking 2 text boxes (1 is a date) to a report

[PavelowFE]

Back for more great help.

Scenario - two tables, one fields of data (text) to include date fields (Start, End), the other with a field (Comment) and a date field (Comment Date).

My report is based on a query from of the first table.

I included a subreport of the second table. I want the comment to post if the date of the comment falls between the dates that are input on a main form (which remains open).
I.e. I have To and From text boxes on the report that show the dates the user enters on a form. I want that same thing for the Comment field, but only if the date the comment was input falls between those two dates.

Thanks.

Vince

 

[PavelowFE]

Here's what I'm starting with for the code. Just need something like an If/Then statement would be in Excel.

WHERE [Forms]![Switchboard]![Date Range]![Start Date] And [Forms]![Switchboard]![Date Range]![End Date];