Finding out which table a bound field belongs to

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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
 
Back
Top