Results 1 to 3 of 3

Combo to find record on report

  1. #1
    djclntn is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2011

    Combo to find record on report

    Hi, I have a Report with list of employees (45-Employees) with their monthy CountOfDays (worked), SumOfHrs, & SumOfErngs. So I want to make the 'Employees' a Combo Box in this Report so that (I envision) instead of having to scroll down the Report to find 'Wayne Simmos' which of course woud be at the bottom of the Report, if 'Employees' was a Combo Box could I choose 'Wayne Simmos' from a Combo Box list?

    Similar to Form I went through the Combo Box Wizard & I have the Control Source matchig up to the same fields, 'EmployeesID', the Row Source is, SELECT [Employees MnthYr Summary*].[EmployeeID] FROM [Employees MnthYr Summary*] ORDER BY [EmployeeID]; & my Row Source Type is, Table/Query. because I'm drawing the 'EmployeesID' from a query.

    In the Report design view 'EmployeesID' Appears like a Combo Box, howeever when I run the Report 'Employees ID' is NOT a Combo Box. Am I missing a step here...?

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Tulsa, Oklahoma.
    If you want the data to be interactive - why don't you just use a Form?

    I don't know that you 'cannot' make a report interactive, but my personal experience has been to use reports to display a set of data - and if I want to give my users interactive search capability - then do that on a Form.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Nevada, USA
    I edited the thread title to make it more meaningful to future users than "Combo box issues".
    Paul (wino moderator)
    MS Access MVP

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

Similar Threads

  1. Best way to find a record?
    By Drak in forum Programming
    Replies: 3
    Last Post: 01-31-2012, 09:40 PM
  2. Find record
    By hithere in forum Programming
    Replies: 11
    Last Post: 01-10-2012, 03:26 PM
  3. Can't find records in combo box
    By darklite in forum Forms
    Replies: 6
    Last Post: 07-07-2011, 01:33 PM
  4. Replies: 5
    Last Post: 11-13-2010, 03:56 PM
  5. How to Find a Record
    By lschlitt in forum Programming
    Replies: 2
    Last Post: 09-09-2006, 05:24 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
Tech Forums: Microsoft Office Forums