Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224

    Unanswered: using form values in report

    I get the beginningdate and endingdate from a form called selectdate
    How do i display these values in a report

    i tried puttinga text box and setting the control source to
    =forms!selectdate!beginningdate and =forms!selectdate!endingdate

    but it didnt work

  2. #2
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by fullymooned
    I get the beginningdate and endingdate from a form called selectdate
    How do i display these values in a report

    i tried puttinga text box and setting the control source to
    =forms!selectdate!beginningdate and =forms!selectdate!endingdate

    but it didnt work
    Hi fullymooned,

    Here ya go:

    ="From " & [EnterBeginningDate] & " Through " & [EnterEndingDate]

    Place that in a TextBox and you have it. Copied directly from my report which does the exact same thing.

    have a nice day,
    Bud

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Quote Originally Posted by fullymooned
    I get the beginningdate and endingdate from a form called selectdate
    How do i display these values in a report

    i tried puttinga text box and setting the control source to
    =forms!selectdate!beginningdate and =forms!selectdate!endingdate

    but it didnt work
    Instead of a text box on your report use a Lable and use its caption to show your desired output

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Example:
    In the form open Event put


    PHP Code:
    yourLable.Caption"Between " Forms!selectdate!beginningdate " And " Forms!selectdate!endingdate

    OR

    yourLable.Caption="Between " Forms("selectdate").beginningdate " And " forms("selectdate").endingdate 

Posting Permissions

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