Results 1 to 2 of 2
  1. #1
    italianfinancier is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    25

    Post List in Report Shows All Items in Table, But I Only Want...

    I have a Form that users enter a customer number into and a Report is generated based off the customer's information in a Table. The problem is, when the report generates, it just puts that customer's data on the top row, but shows all the other customers data below it. I need it to only show the customer entered into the form please. Any help would be IMMENSELY appreciated. Does it have anything to do with the Control Source field in the Preferences of the list in the Report?

    The attachment shows everything so you can see where I am...



    ~ Chris

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    It is odd that the desired record shows as the first record and not sorted with all the records.

    Show the code that opens the report and the RecordSource query of the report.
    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.

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

Similar Threads

  1. Select multiple items from list box
    By sharmaprashant22 in forum Queries
    Replies: 2
    Last Post: 05-05-2011, 12:18 PM
  2. Replies: 5
    Last Post: 04-04-2011, 09:57 AM
  3. Edit List Items
    By Broderhol in forum Forms
    Replies: 3
    Last Post: 02-23-2011, 05:51 PM
  4. Highlighting Items in List Box from Table Data
    By swalsh84 in forum Programming
    Replies: 2
    Last Post: 01-25-2010, 08:55 AM
  5. list box items
    By thewabit in forum Forms
    Replies: 12
    Last Post: 01-01-2010, 08:59 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