Let me rephrase the question, both responses dont even come close to the unknown answer.
My questions does not indicate I am working with 2006 or 2007 versions of access. Within access, I have a table named 2006 emp med file, and a form we enter data into that populates the 2006 emp med file. For the new year, I right clicked on the 2006 emp med file, then "save as" and named it as 2007 emp. med file. Then I stripped out the total amounts of dental useage for that field for all employees. Saved the file so that the 2006 data is removed, and that field contains no data in that column for 2007.
However when I go back to the form, it's accessing the 2006 table, instead of the 2007. So I guess this is a linking issue, to link the existing form to the new 2007 table. The stripped data has nothing to do with my question, it's simply a comment to the question. I could have stripped all the data from the fields in the 2006 table, and started a new year, but then employees names, hire dates, etc. would have to be re-inputted into the form to populate the 2007 database table.
There is no problem with the form, and it does work, but is attached or linked to the 2006 table. I want it attached to the 2007 table. When using the 2007 table, the dental field should be blank, ready for input into the new year table, not showing data from 2006. So the questions is this: How do you link last years form, to the new 2007, "saved as" table? Thanks, Paul