Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: Display query criteria on the report which the query supplies the data?

    I have a report based on a paramter query, which prompts to enter begining and ending dates on each run. Is there an easy way to have the dates displayed on the form.

    I did it the poor man's way and currently have the report prompt the user to enter the dates over again but I would like to eliminate the requirement for double entry.


    Thanks
    D

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8

    Try this

    Build The Form with the Date Feild in it

    save it and open it

    know design the query

    where you have [ Question ] delete

    right click and click build

    the expression builder should open

    Just drill down the 1st window and look for the
    Forms open that
    then click Loaded forms
    then click the Form that is open
    then DOUBLE click the feildname

    then click ok

    then in the Criteria it would have written

    Forms![the_form_name]![This_is_the_feildname]
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    You can do it another way, you don't need to enter the Parameter just make two TextBoxs on your Form, letting the user to enter the dates. These values will be the parameter for your Query as well for your Report using the Forms!yourFormName.yourTextBoxName

    Hope it is clear and helps you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •