Display Table Name

  • Thread starter Thread starter jschping
  • Start date Start date
J

jschping

Hi,

Is there any way to code a text box to display the name of the table that
I'm using for my query? I don't want to hard code it, since I have other code
that changes the RecordSet property.

Is there a way to have it dynamically become the name of the table that one
of the fields is coming from?

Thanks,

John Schping
 
john
to get the query name use something like =RecordSource
in the unbound textboxes recordsource
then use a query name that references the tables name

Barry
 
Hi,

Is there any way to code a text box to display the name of the table that
I'm using for my query? I don't want to hard code it, since I have other code
that changes the RecordSet property.

Is there a way to have it dynamically become the name of the table that one
of the fields is coming from?

Thanks,

John Schping
Click to expand...

Not easily, since a Query could very well reference more than one table: you
can have Joins, Subqueries, DLookUps... the expression "the table" is
ambiguous!

How do these recordsets differ? Do you perhaps have several
identically-structured tables for different subsets of your data? If so,
that's a Very Bad Idea....
 
Back
Top