When i tab from one subForm to another, how do i prevent Access from saving the Data in the first subForm. When sub1 loses focus, it automatically saves the data in all fields of sub1 to the table it is linked to and i need to find a way to prevent this. If anyone has any ideas please let me know. I have tried putting code in the On_Lost_Focus to send a flag to the Before_Update function and then Cancel the save but all that does is simply Cancel the movement of Focus from one subform to the other. Anyways, any help would be truly appreciated. Thanks.
