hey its almost over now there is one small problem left....when i enter some values through a form it works fine...but when i open the form again i see the previous values...i want the previous values to get cleaned up when i open the form again or when i enter the values and they get calculated they shouldn't remain in the form after that.i want a clean form every time i open it...how do i do it........

Oooo Thankyou Soo Much.....i Have Done It.....may God Bless U

the form's record source is a table. form has a button having VB code behind it which runs an update query, then the values in the table are updated. i have only one table in this.what i want this thing to do is: i have 2 forms one to add the values in the table and the other for subtracting the values from the same table.its like i have a particular stock of something, if more comes in i add it to the current stock and when some of it goes i subtract...

Sir,
i am not using an ADP file....as i used Access for the first time i did it with normal db format. Please consider my problem once again....

hello i hav come across this small problem...i made a small project using Access...now what happens is when i enter the data through a form it gets calculated by a query and then gets stored in a table...when i wish to re-enter some values the form opens wid the previous values and when i replace the previous values with the new ones i get an error which says "Write Conflict" and stuff...now tell me wat should i do about it....and i want...