Problems with Syntax to Reference Text Boxes on Report

[JessiRight77]

I want to reference a date range on a report by passing the dates that
I type in my search criteria form to my report. The date range does
not print, however, but displays an #Error message instead.

Am I using the wrong syntax to reference the text boxes? Here is
what I have on my query and report:

Query Criteria:
Between NZ([Forms]![frmQryInventory]![txtStartDate],#1/1/1750#) And
NZ([Forms]![frmQryInventory]![txtEndingDate],#1/1/9999#)

Reference on Report:
="(" & [Forms]![frmQryInventory]![txtStartDate] & " - " &
[Forms]![frmQryInventory]![txt EndingDate] & ")"

Thanks!!

Jessi

 

[Terry]

Jessi,

Two things:
Is your form open when the report is opened?

In the sample you provide below there is a space
between "txt" and "EndingDate" on your report which I
suspect shouldn't be there.

hth

Terry

 

[JessiRight77]

Duh!!! I'll bet I looked at that dozens of times, but did not catch
it! The extra space was the problem.

Thanks!!!
Jessi