I have a membership database that we are using at the fire department for ambulance memberships. I am trying to write some code to be able to have any fire member to search our 2007 database for an existing members by either last name, name, SSN # (or any field in the 07 database would be ideal). If the member is found in the 07 database I would like to be able to push a macro button that would automatically update the 2008 database with the member selected from 07. If the member is new and not in the 07 database be able to add them to the 08 database. This is my first database I have created and am rather new to the functions in access. What I have right now is.

2007 Table with all 07 members
2008 Table


2007 Query
2007 Form showing all 2007 members
A form that I can enter new members to 2008 Table

I know this is a pretty minimal database but we want to be able to build on it every year and be able to send out reminders to all prior and previous members. Any help would be appreciated. If I haven't give enough information let me know.

If this is not possible let me know!