[AccessD] Details of Tables, queries etc being accessed by Forms.

Hey Deano 
Dunno if this is what you want but..

Put a label control in the header called lblMyRecSet and the following code
on load of the form

Me.lblMyRecSet.Caption = "Recordset for this form: '" & Me.Form.Name & "' =
" &  Me.RecordSource 

Should work for tables or SQL statements

See ya - going to bed now 

Have a great day

Darren



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dean Ellis
Sent: Wednesday, 15 September 2004 12:26 AM
To: AccessD
Subject: [AccessD] Details of Tables, queries etc being accessed by Forms.


Hi all,

I have a database that I work with continually. It works well and people are
begining to sit up and take notice of it. (Yes Darren, it's my monster).
When I do development work on it, It's become that large that at times, I
need to go into the design side of a form and read the code to know what
table, or query, or form to open. What I would like to know, and its really
for my own benefit, is; Is there a way that I can have a form (just 1 form),
That I can access, say using a self created shortcut key, that will detail
the table  or query being accessed by the form, the names of any subforms on
the main form? If this can be done, how much info of this nature can I
extract?

Thanks in advance.

Dean Ellis
ph 08 8398 5536
m 0410 474 910
Visit our website: www.jedel.com