Hi Guys!!
I have a database setuped for me, in which there are so many tables, reports, forms and queries resides. I want to change some of the reports to suit my needs but the control source property of any control (i.e. text boxes etc) shows only names of the control or a field the data is coming from, My question is
How can i find that where that particular field is residing in a query or table. coz record source property doesn't mention where the data is coming from? It only shows fields names not the names of the table that field is in or name of the query that field belongs to. is there any work around?