On Thu, 20 May 2010 20:35:01 -0700, Chiki
wrote:

I had followed all the steps you had told me.

Applied the same Control source property of the text box (amount Earned)

still getting ERRORS............

Chiki...

My crystal ball is very foggy tonight.

I cannot see your database.

You have not been communicating.

Please post (as requested!) the names AND DATATYPES of the fields involved.
Please post (as requested!) your actual code.
Please post the actual text of your error message.
--

John W. Vinson [MVP]