Results 1 to 2 of 2
  1. 06-30-2011, 05:34 AM #1
    SwaziMan
    SwaziMan is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    3

    Form to filter reports

    I have several reports, each report is based on a query. These queries are based from the same table. The table is linked with an excel spreadsheet. I want to create a Form that has drop down combo boxes that can help the user decide which report to open



    If anybody could help it would be much appreciated.

    SwaziMan
    Reply With Quote Reply With Quote
  2. 06-30-2011, 08:53 AM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    If the combo had report names:

    DoCmd.OpenReport Me.ComboName...
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Filter data on a form from another control on the same form
    By WonkeyDonkey in forum Forms
    Replies: 2
    Last Post: 11-25-2013, 10:56 AM
  2. filter reports
    By nashr1928 in forum Reports
    Replies: 5
    Last Post: 02-16-2012, 10:58 AM
  3. filter using combo box quit working once form was put on navigation form
    By robsworld78 in forum Forms
    Replies: 2
    Last Post: 08-18-2011, 10:20 PM
  4. Filter On a Form
    By bopsgtir in forum Forms
    Replies: 2
    Last Post: 04-07-2011, 09:53 AM
  5. Access Reports - Applying a subform filter
    By AMCUser in forum Queries
    Replies: 13
    Last Post: 06-25-2010, 07:32 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums