Problems with Syntax to Reference Text Boxes on Report

  • Thread starter Thread starter JessiRight77
  • Start date Start date
J

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
 
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
 
Duh!!! I'll bet I looked at that dozens of times, but did not catch
it! The extra space was the problem.

Thanks!!!
Jessi
 
Back
Top