H
Hise
Hi,
I've created a form that has a [forms]![form 1]![startDate] field on it and
a [forms]![form 1]![endDate] field on it. Also on this form I have a button
"Lauch Chart" and "Launch Detail".
The "Launch Detail" button does an OpenQuery on a parameter query that has
the form1!startDate and form1!endDate in the selection criteria. Launch
detail works and I can see that the correct data has been retrieved (using
the form variables in the criteria).
The "Launch Chart" does an Open Report on a report that contains a "static
chart" (ie Chart Wizard generated chart) based on the same parameter query
that "Launch Detail" uses. This button generates an error "The Microsoft Jet
database engine does not recognize 'Forms!Form 1!startDate' as a valid field
name or expression"
Any assistance would be greatly appreciated.
--Hise
I've created a form that has a [forms]![form 1]![startDate] field on it and
a [forms]![form 1]![endDate] field on it. Also on this form I have a button
"Lauch Chart" and "Launch Detail".
The "Launch Detail" button does an OpenQuery on a parameter query that has
the form1!startDate and form1!endDate in the selection criteria. Launch
detail works and I can see that the correct data has been retrieved (using
the form variables in the criteria).
The "Launch Chart" does an Open Report on a report that contains a "static
chart" (ie Chart Wizard generated chart) based on the same parameter query
that "Launch Detail" uses. This button generates an error "The Microsoft Jet
database engine does not recognize 'Forms!Form 1!startDate' as a valid field
name or expression"
Any assistance would be greatly appreciated.
--Hise