Results 1 to 3 of 3
  1. #1
    jesustain is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2014
    Posts
    2

    Subreport doesn't show all the records properly

    Hi,

    I have a problem with the report of my database. That report gets the records from a query and its subreport gets them from another one. The queries are working good, but the subreport sometimes doesn't show the last record given by its query. I checked it only happens when the result is 14 records, and then the subform only shows 13. If there are more or less than 14 records all is good.

    I've tried to resize the subreport control, to change few features,... and nothing works.

    What could I do?

    Thanks in advance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    What about the LINK CHILD FIELDS, MASTER FIELDS? Are you setting those? It may filter out records.

  3. #3
    jesustain is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2014
    Posts
    2
    Ranman256 you where right, those properties weren't set properly. I thought it was enough getting the records from a query filtered by the value of a text box. It was a strange thing since when the subreport was opened alone was giving the correct results, but when it was opened embedded in the main report, sometimes the last record didn't appear.

    Thanks a lot!!!!

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

Similar Threads

  1. Replies: 3
    Last Post: 04-11-2014, 05:54 PM
  2. Replies: 3
    Last Post: 01-31-2014, 09:13 AM
  3. Replies: 10
    Last Post: 11-20-2013, 04:18 PM
  4. Why doesn't RTF text display properly in report?
    By kenton.l.sparks@gmail.com in forum Access
    Replies: 1
    Last Post: 05-02-2012, 07:30 PM
  5. Combo box doesn't work properly
    By joe1987 in forum Forms
    Replies: 9
    Last Post: 11-10-2011, 04:34 PM

Tags for this Thread

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