J
Jerry
Hi.
I am working on an Access 2000 db in Access 2003 (using 2000 format). In
my original 2000 database, I would create properties in VBA (using Property
Let and Property Get statements) for my forms and use them as criteria in
queries. For example, if I had a report that should show data for a
specific date range, then I would create properties of a form (call it
"frmReport"), and name those properties ReportStartDate and ReportEndDate.
Then, in the design of the query that the report is based on, under the
criteria for a date field, I would add ">=
[Forms]![frmReport].[ReportStartDate] and <=
[Forms]![frmReport].[ReportEndDate]" I would prompt the user for those
dates, set the values for the properties, then open the report. This worked
without fail.
When I run this database under 2003, I get the "Enter Parameter Value"
window for both "[Forms]![frmReport].[ReportStartDate]" and
"[Forms]![frmReport].[ReportEndDate]". Does anyone know why this would not
function as it did in 2000?
Thank you,
Jerry
I am working on an Access 2000 db in Access 2003 (using 2000 format). In
my original 2000 database, I would create properties in VBA (using Property
Let and Property Get statements) for my forms and use them as criteria in
queries. For example, if I had a report that should show data for a
specific date range, then I would create properties of a form (call it
"frmReport"), and name those properties ReportStartDate and ReportEndDate.
Then, in the design of the query that the report is based on, under the
criteria for a date field, I would add ">=
[Forms]![frmReport].[ReportStartDate] and <=
[Forms]![frmReport].[ReportEndDate]" I would prompt the user for those
dates, set the values for the properties, then open the report. This worked
without fail.
When I run this database under 2003, I get the "Enter Parameter Value"
window for both "[Forms]![frmReport].[ReportStartDate]" and
"[Forms]![frmReport].[ReportEndDate]". Does anyone know why this would not
function as it did in 2000?
Thank you,
Jerry