Subdatasheets

[Joshua A. Booker]

Hi There,

I have several related tables that I like to view and edit in a hierarchal
view by using the subdatasheets functionality.

This works in the BE but in the FE I don't see the subdatasheet plus signs
and the Insert | Subdatasheet menu option is not enabled. Are they not
supported on linked tables?

Can subdatasheets be controlled in code? i.e. update the subdatasheet table
and relationship and/or expand and collapse using code on opening the table.

TIA,
Josh

 

[Roger Carlson]

Subdatasheets work for small databases where users are working directly in
the tables.

But if you're going to create an actual Access application (which you seem
to be doing by creating a back-end), your users should never work directly
in the table anyway. You would be much better off creating forms and
subforms to control this rather than subdatasheets.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Joshua A. Booker]

Roger,

Thanks for the info. I'm aware of the limited uesfullness of subdatasheets.

Could anyone please answer my questions regarding whether they can be
controlled in code and whether there is a way to use them in an FE when the
tables reside in the BE.

TIA,
Josh