Title to contain parameters from form

[EdAROC]

When I started this report I thought I had the skills. Oops.

Want the 2nd line of the title to read the date range specified by the user. The values are coming from the form, txtDate1 and txtDate2.

Line Example: 12/01/06 - 12/31/06

I tried the following in a text box on the report, abbreviating some:
#1
=Format(Me.txtDate1,"mm/dd/yy") & " - " & Format(Me.txtDate2,"mm/dd/yy")
The 1st page displays OK, other pages display "Error?"

#2
Creating a text box on the form that uses the formula from #1, the 1st page of the report displays OK, other pages display "Name?"

Help!

 

[PHV]

The values are coming from the form, txtDate1 and txtDate2
What about something like this ?
=Format(Forms![name of form]!txtDate1,"mm/dd/yy") & " - " & Format(Forms![name of form]!txtDate2,"mm/dd/yy")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[EdAROC]

My mistake - I abbreviated out all that detail. I used Expression Builder to build the formula, so, you know it had all the details.

Dang! Nice try.

 

[EdAROC]

Hmmm. The problem no longer exists.
Case closed (although the issue is not solved, unless all I have to do is close the file and re-open it later).