Starting/Ending Date as Parameter Values

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

I have a report that uses a query that, in turn, uses the
following criteria: Between [Forms]![ Date Selection]!
[Starting Date] And [Forms]![Date Selection]![Ending Date].
After I enter the starting and ending dates I am again
asked for the input parameter [Forms]![ Date Selection]!
[Starting Date].

The original form and report only used the ending date as
part of the criteria - I just added the "starting date"
parameter to the form and query. Any ideas why it is not
accepting my form input for starting date?

By the way, the macro that controls the form has the
following actions: OpenForm, SetValue, SetValue, Close.
 
Well assuming you cut and paste the Criteria and it isn't a typo, there is a
space in front "Date Selection" in the Starting Date part. Access cannot
find the form, so it asks you to input it.
 
Roger, you were right, thanks alot.
-----Original Message-----
Well assuming you cut and paste the Criteria and it isn't a typo, there is a
space in front "Date Selection" in the Starting Date part. Access cannot
find the form, so it asks you to input it.
--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I have a report that uses a query that, in turn, uses the
following criteria: Between [Forms]![ Date Selection]!
[Starting Date] And [Forms]![Date Selection]![Ending Date].
After I enter the starting and ending dates I am again
asked for the input parameter [Forms]![ Date Selection]!
[Starting Date].

The original form and report only used the ending date as
part of the criteria - I just added the "starting date"
parameter to the form and query. Any ideas why it is not
accepting my form input for starting date?

By the way, the macro that controls the form has the
following actions: OpenForm, SetValue, SetValue, Close.
Click to expand...


.
Click to expand...
 
Back
Top