Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Enter Paramater value/ report

Author  Topic 

pretoria
Starting Member

6 Posts

Posted - 2005-08-07 : 16:06:04
I have numerous reports based on queries with a criteria date select string. So when I Preview the report I first get asked "Enter start date:" etc.

In all reports I have entered a text label with date control source stating "=[Enter start date:]" to have the start date parameter value printed on the report. All straight forward up to now. Anyone have an idea why with some other reports when I enter the exact same code the report preview text label renders "#name?". I don't get it?? So I thought maybe I should change it to something completely different. "Start book date". I changed it for both query and report label and still get "#name?".

Completely clueless and I have rechecked them all. The labels are all consistent with the criteria string in the query.

thanks.

SMerrill
Posting Yak Master

206 Posts

Posted - 2005-08-10 : 21:01:20
Usually, the name of the text label itself is set to "Enter Start Date:" instead of "txtStartDate". Make sure your controls are not named the same as that which your control source resolves to.

~ Shaun Merrill
Seattle, WA
Go to Top of Page
   

- Advertisement -