Results 1 to 3 of 3
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Combo Box On a Report (A2K SR1)

    Is it possible to put a combo box in the header of a report such that as the user selects a different piece of data in the combo box, the on change event of the combo box will launch a query that changes the dataset of the report and ultimately modify the report based on the data selected? (i.e, the report results will dynamically change as the user selects new data from the combo box)

    I can do this in a form, however, want to know if it can be done directly in a report and avoid the form altogether.
    <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Regards,

    Gary
    (It's been a while!)

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box On a Report (A2K SR1)

    All data on a report are static. A combo on a report is not usable (it only display data but is not accessible). You have to do on a form before opening the report.
    Francois

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Combo Box On a Report (A2K SR1)

    Thanks Francois. I suspected as much..... Darn..... <img src=/S/frown.gif border=0 alt=frown width=15 height=15>
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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