Adding a variable to a report

I use a criteria statement to select between dates from a query. I don't use the prompt in the query because of other selections that are part of the criteria. I have public variables set up for vbdate and vedate. I want these dates to appear on the report as a from to. I've tried using the standard =([vbdate]) but I only get the #error in the field. Can someone tell me what I'm doing wrong. Thanks for any help.

Tom

"CD Tom" wrote in message
...
I use a criteria statement to select between dates from a query. I don't
use the prompt in the query because of other selections that are part of the
criteria. I have public variables set up for vbdate and vedate. I want
these dates to appear on the report as a from to. I've tried using the
standard =([vbdate]) but I only get the #error in the field. Can someone
tell me what I'm doing wrong. Thanks for any help.

This is covered in help.
You have to tell it where the information comes from

Usually it will be something like Forms!MyFormName!MyDateFieldName

= "From " & Forms!MyFormName!MyStartDateFieldName & " and " &
Forms!MyFormName!MyEndDateFieldName