How do I find origin of table from a form?

[devarts]

I am trying to find the origin of some data from a form; specifically, what table or query it points to. Is there any way to know what table is being used? The control source tells me what fields are being pulled but not from what table.

[Seth Schrock]

Under the form properties, Data tab, there is a property call Record Source. In this property there will be the name of the table/query that the form is bound to, or SQL code. If it is SQL code, then it would start with the word SELECT. If this is the case, then right click on the property and select Zoom. Then all you have to do is find the word FROM and this will tell you the table/query(s) where the data is coming from.

[zmbd]

Might I inquire why you are after this information? There may be an easier way to accomplish your goal.

[devarts]

I'm trying to pull information together but I only know where to find it on a form. I need the information off the query or table that it is connected too.

[zmbd]

That's a fairly opaque explanation... I think that you need to get in contact with the database designer or administrator to find out more details about your database before you get into something and muck it up.
(^_^)