Hi
I am fairly new to Access, and have to decided to make the move after realizing my Excel spreadsheet would soon meet it's full potential. I have created a database linked to a form (which includes a sub-form) which handles all my daily purchase orders. Still busy building it, but have run into a bit of a snag...as soon as I press Tab or Enter to move focus to the next Control, the form automatically adds what I have entered into it so far to the table as a new record. Obviously, when I move on to the sub-form to enter the rest of the information and save it, it tells me that it cannot add duplicate entries into the table unless I enable it. I have a "Save Record" button on the form as well, but so far this is pretty useless. Is there an on-load macro or something I can run which will keep the form from updating the table automatically UNTIL after I have clicked the Save Record button?