I currently have 3 forms and they all work fine, except 1 problem. If i enter data in form 1 and save it using a button and macro that basically says save record then clear form it does save it as record 1. If i then enter a record on form 2 and use the same save method, it does save the record but again as record 1 and overwrites the form 1 record. I cannot for the life of me remember how to solve this issue (its been 15 years since i learned basic access). Can anyone help please?