Finding out which table a bound field belongs to

D

Daniel

I need to find out to which table a bound field belongs. Is there an easy way
to do this?

My current approach involves "parsing" the recordsource property to find
out. However, this doesn't work when the recordsource is just the name of a
query. Is there any way to get the sql behind a query?
 
D

Daniel

Hmm, it would probably be a better idea to use the sourceTable property of
the corresponding field in the RecordSet of the form. Think I'll do that
instead.
 
N

Nikos Yannacopoulos

Daniel,

There was a post earlier today in the microsoft.public.access newsgroup,
titled "Show the name and SQL of all queries in a database". have a look
at my answer to it, it may help you.

HTH,
Nikos
 
Top