0

I have an already created database in MS Access 2003. It has forms that are used to enter data into tables. I want to create a report that shows the values entered through the forms. I am trying to find where the data gets stored when entered through the form so that I can create a report on that table, and I am not able to find it. Can someone please tell me how I can do this?

amir shadaab
  • 469
  • 3
  • 9
  • 23
  • maybe you need something like this? http://stackoverflow.com/questions/12901458/how-would-i-make-a-form-which-searches-for-values-in-all-tables-of-a-database-in – fthiella Nov 12 '12 at 17:46
  • 2
    Can you open the form in design view and look at the query or table which is its record source? – HelloW Nov 12 '12 at 17:51

1 Answers1

-1

I would add an additional field to your back end tables, and write the name of the form directly into the record. That way you can query it later.

cheshirepine
  • 113
  • 2
  • 8
  • There are so many tables in the database, should I query all the tables to find out where information is going? And then that would give me an overhead of adding and deleting fields in the tables – amir shadaab Nov 12 '12 at 17:39
  • 1
    I am afraid I consider this to be a very strange answer and I cannot see that it has any real value. – Fionnuala Nov 12 '12 at 20:47