Home > IT Answers > Microsoft Windows > Access 2007 table versus forms
Gpl
5 pts.
 Access 2007 table versus forms
Access 2007, Access forms, Access Tables, Microsoft Access
I use Access for contact mgmt. database. I have my "main" table that has all my client info. If I create a form (looks like spreadsheet) and it is populated by the names in the table and I need to delete names from the FORM, not the original table, does it delete also from the main table?

Software/Hardware used:
ASKED: April 20, 2009  2:45 PM
UPDATED: April 21, 2009  6:49 PM
RELATED QUESTIONS
Answer Wiki:
Yes - that would delete the records from the original table I believe that you can create a query excluding the rows you don't want to see and build the form over the view. Phil
Last Wiki Answer Submitted:  April 20, 2009  4:12 pm  by  philpl1jb   44,070 pts.
All Answer Wiki Contributors:  philpl1jb   44,070 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Yes, good comment by Philipl1jb. In Access database, if you delete the record from a query then the record is deleted from the main table. Same is true for changing/modifying the query result – it will change the main table.

You can filter the record set – by opening the query in Design mode and selecting proper condition parameters.

SbElectric
 2,510 pts.