Results 1 to 2 of 2
  1. #1
    p4ck3tl055 is offline Novice
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    4

    Thumbs down Create a report based on a pop-up form

    It's a little complicated to explain, but I'll try. Access 2007 is being used.

    What I'd like to do is have my users select a button on the switchboard. This would bring up a form consisting of a combo box with the selection criteria (say employee names) and a "create report" button.

    When a user choses an employee from the combo box and hits the "create report" button on the form, a report showing information on that employee would come up on the screen.



    I think what I'm trying to do is have the value of the combo box become the criteria of a query on which the report is based.

    Is that even possible?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Your "Create Report" will probably use the OpenReport command so just supply a WhereClause from your ComboBox.

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

Similar Threads

  1. Replies: 5
    Last Post: 04-01-2010, 03:48 PM
  2. Replies: 3
    Last Post: 02-17-2010, 02:29 PM
  3. Replies: 1
    Last Post: 03-02-2009, 11:54 AM
  4. Replies: 0
    Last Post: 02-15-2009, 09:14 PM
  5. Replies: 1
    Last Post: 02-02-2009, 05:52 AM

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