Retrieve name of current table?

[Christine Pearc]

At this point in my (early life) coding experience, I feel really silly having to ask, how do you get the name of the table source for a current form or control (field)? I've been looking everywhere and can only find info on, for example, retrieving path and directory names, all tables in a database, etc. This should be SO simple!!--grrrrr!

 

[pono1]

'form's recordsource
   msgbox Me.RecordSource
'textbox's controlsource 
   msgbox Me.TextBoxName.ControlSource

Experiment using "intellisense" by simply typing Me. in the code window. All sorts of "properties" and "methods" pop up. Select one and then highlight it in the code window and press F1 and, with luck, a description of what you selected will pop up within the Help file.

Regards,
Tim

 

[Christine Pearc]

Retrieve name of current table? - Thanks

Thank you, Tim. Now, why didn't I think of that!!!