Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Putting Unbound Controls in a Report (2000)

    Hi,

    I would like to know if there is anyway to put an unbound control on a report. I have a habit of using two unbound text controls on forms to open up reports between a certain date range. They are called StartDate and EndDate. I would like to know if it is possible to have the dates that the user enter's into these controls show up on the corresponding report that the form opens.

    Thanks,
    Leesha

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Putting Unbound Controls in a Report (2000)

    Yes, that is very well possible. Say that your form is named frmSelect.
    Put a text box on the report and set its Control Source property to =[Forms]![frmSelect]![StartDate] and then another text box with Control Source =[Forms]![frmSelect]![EndDate]
    Set the Format property of the text boxes to your favorite date format, e.g. Long Date.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Putting Unbound Controls in a Report (2000)

    Oh Hans thank you!!! I wondered if this would be the way to go but figured before I spent hours experiementing I'd just ask the question. I've been using this approach with forms and for weeks now since you gave it to me in one of my previous posts but I didn't know it could also be done with reports.

    Thansk again,
    Leesha

  4. #4
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Putting Unbound Controls in a Report (2000)

    Leesha,

    Make sure your form is open when you open the report. Otherwise, the references Hans' recommends won't work.

    In these situations, I usually add a command button (e.g., labeled "Preview Report") on the form that opens the report. So the routine would be something like... open the form, fill in the fields, click the button to generate the report, view/print the report, close the report, close the form.

Posting Permissions

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