referencing a table

[scratch]

you can reference a field in a table with

Me.txtTextbox.ControlSource

What I want to do: given a control i want to be able to get the table name in which the controlsource (ie. the field) to the control resides. Any suggestions?

PS I don't want to use a form reference (eg. Me.RecordSource) since the controlsource may have info from a different table then the rest of the form.

scratch

 

[KenHigg]

you can reference a field in a table with

Me.txtTextbox.ControlSource

What I want to do: given a control i want to be able to get the table name in which the controlsource (ie. the field) to the control resides. Any suggestions?

PS I don't want to use a form reference (eg. Me.RecordSource) since the controlsource may have info from a different table then the rest of the form.

scratch

I would think that the means that you use to populate a text box, ie RecordSource, dlookup, custom function, etc, would determine how you go about getting the table name or query name. I doubt there's a do all type method to doing this...