Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005

    How about creating a drop down menu in a report?

    In a report, I have sections of my business broken down into 5 different codes (Accounting - Code A, Engineering - Code E, Support - Code L, etc.). I have created a report displaying code activity and all of the corresponding events attended by these codes. What I would like to do is create a drop-down menu for the codes (if possible) to display events attended by a particular code ONLY. EXAMPLE. - If I want events attended by Code A only, I can select code A and it displays Code A events only. A drop-down box would be nice, but anything to this degree would suffice. Is this something I need to create in a query and integrate it into a report?

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Nope, you can't do that directly in a report. If you really need that kind of funtionality, look into Crystal Reports.

    What you CAN do in Access, however, is create a drop down on a form and then filter the report by the value selected.

  3. #3
    Join Date
    Dec 2005
    Wilmington, DE - USA
    Quote Originally Posted by StepUP
    What you CAN do in Access, however, is create a drop down on a form and then filter the report by the value selected.
    That is a useful technique. Another thing you could do is modify the Recordsource of your report so that it includes a WHERE clause in which you can supply a runtime parameter to do the filtering:

    WHERE YourCodeField LIKE "*" & [Code starts with] & "*"

    If your user enters A in the parameter prompt, you get the 'A' codes. If your user enters a *, you get all the codes.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. creating a report in this manner
    By jiwatramani in forum Reports
    Replies: 1
    Last Post: 11-07-2008, 11:39 PM
  2. Drop Down Menus
    By iambia in forum Access
    Replies: 1
    Last Post: 01-25-2008, 02:05 PM
    By ranjit_dutt in forum Programming
    Replies: 0
    Last Post: 04-13-2007, 08:39 AM
  4. Startup Menu Greyed Out
    By slash75 in forum Access
    Replies: 0
    Last Post: 02-14-2007, 04:55 PM
  5. Replies: 1
    Last Post: 12-06-2006, 05: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
Other Forums: Microsoft Office Forums