• Putting Unbound Controls in a Report (2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Putting Unbound Controls in a Report (2000)

    Author
    Topic
    #390890

    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

    Viewing 0 reply threads
    Author
    Replies
    • #696134

      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.

      • #696136

        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

      • #696140

        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.

    Viewing 0 reply threads
    Reply To: Putting Unbound Controls in a Report (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: