I'm sorry if i posted so many topic, I'm stillnew with this access. I had another problem and i hope you guys would help me. I want to make a calculation on the form.I had a form thet required the user to enter the beginning date and the ending date, when the user key in the date and click the calculate button, the system should calculate the sum pf amount between the date, for exampale from 01/08/00 to 30/08/00 and display the result on the form itself. I had a report that would display the same thing, it works, but when i tried to copy and paste the control source of the text boxes on the report to the text boxes on the form it doesn't work. can anybodu help me, i'm getting nearer to my dateline...thank you in advanced

the possible thing is they are both using different names or different record source. i don't reccommmend copying a field in the report to a form because you most likely come across problems like this. it doesn't take long to come up w/ an exact type of field. you can save time by doing this manually.

the structure of your report and form is most likely different.

[This message has been edited by gino (edited 08-08-2000).]