Urgent -- pl help

[gdanalakshmi]

I am running a report from a form and specify the start date and end date in the form. I give the startdate in the query associated with the report. I get the following error?

The Microsoft Jet Database engine does not recognize
'[Forms]![ReportMenu]![StartDate]' as a valid field name or expression

What could be the problem?

 

[jadd]

Hi there,

It looks like you're on the right track.

Is the [ReportMenu] the correct name of your form?

Is your [StartDate] the correct name of the unbound text box on the form?

 

[gdanalakshmi]

yes , it all correct.

 

[cath240]

try having the report menu form opened when you are running the query.