That's exactly what I want john but as you said my arrangement isn't right and I am not experienced with vba yet. I am currently in the process of self-teaching myself. I need a little help/guidance. I need the data base to keep all data for every record and every field. I work for the government in transportation and this is what we are attempting to do so we can get away from excel.. The only thing that need new data every month is fuel, days, trips, mileage, month, and if you want to get technical year which only changes every 365 days but for this database I want it to be entered every time data is entered. originally wanted the year to stay the same with every new update but I am new at this and it was taking to much time to try and fix it and I had no one to get guidance/help from. Luckily I found this site and am praying you guys can help. If this site helps me fix this database it as well as me will get all the credit. Maybe someday I will be in a position to help some new.