Results 1 to 4 of 4
  1. #1
    ClassyD is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    13

    Report - Can a combo box be created on a ACCESS Report


    What do I use to place a list of people on a Access Report and given the choice to select one name from the list?

    Also, Can I place an automated signature on a Access Report tied to a table?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Reports are not intended to be interactive. However, in ReportView a listbox (not a combobox) can be clicked on and value returned. What do you want to happen?

    What do you mean by 'signature' - a graphic of actual handwriting?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    A command button in a report's detail section knows which record that button is on when you click it. So you can get a name if that is part of the record, but if you take this route, you'd best consider the possibility that there is no name in some of the records. To me, the view looks kind of silly, and presents buttons on reports that maybe people start clicking out of curiosity. Why not just present the data in a form, which is supposed to be interactive?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    I prefer to use a form to collect the criteria to be used to select the records for the report. This keeps the report simple. I also design my forms to be generic. This allows them to be shared with other reports.

    Here are some examples you can use:

    Report Dialog Examples

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

Similar Threads

  1. Newly created report is lost
    By Skydiver16 in forum Reports
    Replies: 2
    Last Post: 02-16-2017, 03:36 PM
  2. Replies: 2
    Last Post: 02-01-2017, 06:15 AM
  3. Replies: 0
    Last Post: 02-25-2015, 08:09 AM
  4. Report not created for new id
    By meikke in forum Reports
    Replies: 1
    Last Post: 02-17-2012, 09:37 AM
  5. Replies: 4
    Last Post: 01-30-2012, 06:04 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