I have a table of all of our memberships from 2008 and we are going to start enrolling members for 2009. I am new to Access and am wondering if there is a way that I can say type in a SSN and if it matches a prior member from 2008 it would pull that member up so we can add them to the 2009. If we type in the SSN and no member is found that it will allows us to add that new member? I am also trying to keep the 08 members separate from the 09 members?

Thanks for any help in advance!