SQL DataSource error...

[ItIsHardToProgram]

I have the following Query running a Form. Deproj is the subform of Dépense, the childlink is FDnumero and the parentlink is No_F_Dep

SELECT Dépense.*, Sum(DepProj.soustotal) AS Tototal FROM Dépense INNER JOIN DepProj ON Dépense.no_f_dep=DepProj.FDNumero;

Apparantly when I try running this query it does not detect the Fields in Dépense..... I can't see whats wrong in my query, could some one try to enlighten me please?

Thank you all.

 

[ItIsHardToProgram]

I passed through VB and made it calculate after update and on change of every single related txtboxes, but I don't like this way... if any one has any better idea......

(passing through a query event does not work since the informations don't save in SousTotal......)

Another question, I am wondering will this add up EVERY SINGLE CELL in SousTotal or only the record in use.... thanks.