Prevent subform from being displayed in a mainforms datasheetview. (1 Viewer)

[AHeyne]

Hi folks.

I would need some help with Access 2003.

I have a mainform, which contains a subform.
The mainform is bound via the recordsource-property to a query.
The subform is NOT bound to any recordsource and is NOT 'bound' to the mainform in any way.
It is just beeing displayed (i use it for custom filter technics).

My problem is now:
When i switch the mainform to the datasheetview, i will have (unluckily) the possibility to 'expand' each recordset via the plus-symbol on the left side of each record.
When i do this, my subform will be displayed.
But i don't want that!
My target would be, to tell the mainform not to show the subform in it's datasheetview, or better, not to display the plus-symbol at all.

Is there a way to fulfill that?

Regards,
AtzeX

 

[AHeyne]

Hi out there.

Not one did reply?
Is it such an unknown topic?

 

[Rich]

Isn't there a way to turn off the subDatasheet feature ?

 

[AHeyne]

Yes and no.
This table-property seems to be only changeable via code.
But even then, the forms datasheetview does not change it's behaviour. :-/

 

[AHeyne]

Nobody else has an idea?