424,294 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,294 IT Pros & Developers. It's quick & easy.

Split form sub-records showing as form instead of datasheet

P: 62
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_Activities

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
Sep 29 '12 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,285
I think you need to go to the subform and set the default view to datasheet.
Oct 4 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.