This doesn't only apply to opening Tables, directly...when you have Subforms on Datasheet View Forms, the Record on the MainForm appear with a (+) (Plus Sign). To view the Subform(s) for a given Record you click on the (+). In order for all of the Subforms to be dropped down when your MainForm opens, in the MainForm use this code
Code:
Private Sub Form_Load()
Me.SubdatasheetExpanded = True
End Sub
To have them appear 'collapsed,' set it as
Me.SubdatasheetExpanded = False
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007