On Wed, 21 Apr 2010 07:55:01 -0700, kmerid59
wrote:

I have a registration from that has numerous fields and would to like if the
register this year pull all the fields from old over to new db - I can either
use exsisting excel or import old into acess. The member nbr is the primary
key

I am using access 2007

A Form is just a window, a tool to view data in the table. You can't pull data
from a form because it doesn't exist there - it exists in a table.

What is the table? What's its structure (fieldnames and datatypes)? Why do you
think you need a new database? If you have the same data from year to year,
normally you would have two tables, one for the static data and another for
the year to year changing data, in a one to many relationship?

--

John W. Vinson [MVP]