Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    232

    Unanswered: Switchboard creating and buttons

    Hi

    How to create a switch board with buttons that opens up a report(Already created)

    So when the user clicks on the button it will display this report

    2) part is how do i make a list box for the report so that user choses a query ( which is the combination of numbers)
    bigfoots

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    The first part should be easy... use the switchboard manager wizard found under the Tools->Database Utilities menu.

    The second part seems like you have one report and many queries and want to swap the record source on open of the report using vba according to what is in the combo box on a form. I do something similar by using many sub reports and this code in report onOpen to choose which to show:

    Me![Report1].SourceObject = "ProfileFull1"

Posting Permissions

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