subdatasheet name

[Davros]

Hi
I'm using subdatasheets at the moment. problem is i have other subdatasheets with similar named fields which makes it hard for me sometimes to figure out what table i'm looking at. is their a way when you open up the subdatasheet of getting access to include the actual table name in the title bar? it would make my life a little confusing.

thanks in advance

 

[Galaxiom]

Subdatasheets are only for tables and queries. They can be useful in development but since tables and queries should not be directly available to the user, they have no place in the user interface.

Subdatasheets can be made available when using tables and queries as source objects of a form but this sacrifices all control over the display and editing.

Use forms and subforms to display your data. Display the related records in a subform.

 

[Davros]

thanks for not answering the question!
it's not a user interface for anyone else - it's for me. i would like the subdatasheets name displayed somehow so I don't get confused during MY develpoment of the database.

 

[Galaxiom]

Simple answer then - No. Queries and Tables don't have a caption property. Maybe some Windows expert could tell you how do it.

As a kludge you could add a field to the subdata objects to indicate their source.

No need to change the original table or query. Just use them as the base for a query that adds the extra field.

 

[Davros]

thanks
i was thinking of have a field with the table name but i just thought it would be a good idea to have the subdatasheet display its source name that it must have been built into an associated property by the developers. obviously not then.
thankfully i have a pen and some paper
thanks anyway