Determine ControlSource table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sfarkas@visa.com - 25 Jan 2005 19:41 GMT

I have an application with a number of forms, some of which have a
recordsource that is a join of multiple tables. The forms are all
bound forms. Using VBA, I would like to be able to interate through
the controls on each form and determine: a) the controlsource and b)
the table to which the control is bound. Obviously getting the
controlsource of a control is simple. But I don't see how to drill down
to get the table name to which the control is bound.
Anybody know?

Thanks for your help.

Reply to this Message

Paul Overway - 25 Jan 2005 19:59 GMT

Controls aren't bound to a table, they are bound to a field that exists in
the recordsource for your form, which could be either a query or a table.
Aside from parsing the SQL associated with the query used for recordsource,
there is no direct way to obtain the info you seek.

Signature

Paul Overway
Logico Solutions
http://www.logico-solutions.com

>I have an application with a number of forms, some of which have a
> recordsource that is a join of multiple tables. The forms are all
[quoted text clipped - 6 lines]
>
> Thanks for your help.

Reply to this Message