Split form sub-records showing as form instead of datasheet

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sandra Walsh
    New Member
    • Nov 2011
    • 62

    #1

    Split form sub-records showing as form instead of datasheet

    Hello -

    I have a main form with a record source of t_Trips.
    Main form has a split form default view.
    In the properties for the t_Trips table, the Subdatasheet name is set to Table.t_Activit ies

    I have a sub-form called f_ Activities on the Main form linked by Trip_ID.
    f_ Activities displays the Activity_ID of the current Activity.

    When I click on the + sign in my split form, I see the Form view of f_Activities. I can only the see the form for the first record, even if I increase the row height.

    I would like to see the related Activity records in datasheet view when I expand the + sign in the splitform.

    Thank you,
    Sandra
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    I think you need to go to the subform and set the default view to datasheet.

    Comment

    Working...