Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2011
    Posts
    56

    Unanswered: Main Form Only Shows One Record When Subform is Added

    Access 2007 FE
    Sharepoint 2010 BE

    I have a main form in single form view that shows 1 of 675 records when opened. Now if I add a subform that shows records related to a combobox on the main form, the main form on shows 1 of 1 record.

    If I change the default view of the main form to datasheet form view and add the subform again, the main form shows 1 of 675 records. Then I can change to single form view and it shows 1 of 675 records. What am I doing wrong?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    When this happens, what occurs when you click on the 'Next Record' button on the Main Form? Access doesn't always load all appropriate Records on opening, and depending on the number of Records in the Subform's source, it may simply be taking the Access Gnomes a while longer to load all of the Main Form Records with the Subform than it does without the Subform.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Aug 2011
    Posts
    56
    I thought that might be it but next record takes you to adding a new record. Also a single form view main form with datasheet view subform shows all records.

  4. #4
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    119
    Have you checked the form isn't opening filtered?
    Regards
    JD

    Software-Matters

  5. #5
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    What is the data source for the main form? What is the data source for the subform? How are the two linked together?
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •