is anyone has idea about how to cancel update for all records edited in subform? i hav a save n cancel button n a bound field in another table which is linked to the subform in my parent form. i'm facing problem with Access program when i try to insert a new record in multi tab form. error 3163: The field is too small to accept the amount of data you attempted to add. Try inserting or pasti

Whenever I make a program for a user to input data, I always try to make the fields unbound. Once the user is finished I check for any errors and then it is saved to the table. Is it an option for you to have the fields unbound? Are you also asking about an error 3163?

the error 3163 has been solved.. Anyway, I'm still not getting wat u mean by unbound form? if i have few records in my subform? Is dirty property n method can help? i'm facing problem with Access program when i try to insert a new record in multi tab form. error 3163: The field is too small to accept the amount of data you attempted to add. Try inserting or pasti

Is your subform set to single form or continuous forms?

The subform is in a single parent form. lets say the mainform is linked to Invoice table whereas the subform is linked to invoice detail table... how could i cancel the update can i use batchupdating? Do u hav any idea or sample of this? i'm facing problem with Access program when i try to insert a new record in multi tab form. error 3163: The field is too small to accept the amount of data you attempted to add. Try inserting or pasti

One way that I can think of is to create a hidden unbound text box for every bound item on your subform. Before the user updates a bound item (such as on got focus), copy it to the hidden unbound text box. Then if you select cancel, just copy the information in the unbound hidden text box back to the bound item.