Expand SubDatasheets

Okay, so we all know I recommend turning off the SubDatasheet but I can see by the Forums they are still quite popular.  For those of you that are still using them…

When you first open your Main Form/Subform (Datasheet View) it opens closed (Little plus signs).  This is often quite annoying to Users as they are the ones that have to click all those little plus signs to see the data in the SubDatasheet.  So, let’s fix that!

In the On_Load event of the Main Form put…

Private Sub Form_Load()

     With Forms("YourMainFormName")
         .SubdatasheetExpanded = True
     End With

End Sub

Then the next time you open the Form…  Enjoy!