"You can't Assign a value to this object."

[MarcoRed]

Hi! Everybody! I'm Delighted to be here. Today I have a Problem and i unable to solve it.
I have Create a Form that Related to Products (I already have Table that connected to that form). These are the Following Texts I have Create:
Product ID: 1
Product Name: Hard Disc
Quantity: 5 units
Unit Price: $30.00
Total: $150.00
Above, is the text that I have created in a Form of Access. The Problem is That When I try to Total Quantity and Unit Price. So I go to Control Source of Total box (in property sheet), in Total Control Source I type:
=[txtquantity]*[txtprice]
Then I Clicked Ok, and Save. And Then I click "Form View". I opened in Form View. But when I try to clicked on any Navigation Button (like Next, Previous, First, Last ect...), A Pop up Message Appeared "Microsoft Office Access: You Can't assign a value to this object."
(please try to understand)


Thanks in Advance!!

[RuralGuy]

Your form should be based on a query of that table and the Total field should not be in the table. Instead, do the calculation in the query and then simply display the results on your form.

[MarcoRed]

Oh! Thank You so much! I forgot about this! You Reminded me!

[RuralGuy]

You're welcome. Are you ready to mark this thread as Solved?