Multiplying in Continuous Form

[toqilula]

Greetings,

I am trying to myltiply two fields on my continuous form, I have a formula that i put in unbound textbox and works fine, but just for the first row, the next one in a line gives the same value of the first row even that is not correct:
I hope im explaining myself what im trying to acomplishe here.
please find bellow some more informations that will help understending my needs. I really appreciate any help I can get
---
my dba:

Table: itemtbl
ID - AutoNumber/Long Integer/Increment (default created by access 2007)
Item - Text/255
Price - Currency/Euro/Auto
Qty - Number/Single
Total - Currency/Euro/Auto

Continuous Form: fields,
name: Itemtxt
selection type: Text Box
Control Source: Item
---
name: Qtytxt
selection type: Text Box
Control Source: Qty
---
name: Pricetxt
selection type: Text Box
Control Source: Price
---
name: totaltxt
selection type: Text Box
Control Source: Unbound
--------
I have 3 records on table called itemtbl
(this is how its diplayed on my continuous form)
ID Item Qty Price Total
1 Book 1 2.50
2 Pencil 3 1.40
3 TV 2 99.90
------
Agan how to multiply qty with Price and get a sepret value for each line/record/row on my total filed

Kind Regards

 

[boblarson]

Put the calculation in the query underlying the table instead of on the text box.

 

[toqilula]

Thank you very much, I just found the solution. I needed to mut the calculation in control source of my unbound textbox and works perfect

finaly, lol
Kind regards