Search results

My Apologies, I am using the onload event. But the actual SQL code is stored in a function as i'll be requesting it again. I am doing calculations on tax information. So I need to calculate certain rows depending on how they paid. So thats why multiple queries are required.

strSQL = "SELECT Sum(tblPayment.Amount-(tblPayment.Amount*0.1)) AS SumOfAmount FROM tblPayment GROUP BY tblPayment.ContractID, tblPayment.Method HAVING (((tblPayment.ContractID)= " & [Forms]![frmViewMNW].[txtContID] & ") And ((tblPayment.Method)='GST Included'));" Set dbs = CurrentDb() Set rst...

I'm having major issues in an access form where I run a Query and it populates 10 fields or so. From those populated fields I run another query based on a fields value. Now the 2nd query at some point is trying to run when the fields value is not populated, so i'm getting errors. Its a...