I have a form containing a subform.
The form must open in form and datasheet view, but when in datasheet view, the subform access (the "+" sign) must be disallowed.

I've tried
If Me.Parent.Currentview = 2 then Cancel = True
in the OnOpen event of the subform, but this fails to block it ... the header and a single row of data fields appear.

So .... how can you intecept a User Click on the "+" and stop the subform appearing ????

(I'm using Acess-2002)

Many thanks for any solutions.