Subform insert into statement

[nhtraven]

Hi all,

I am trying to insert current data from a subform field into a table. I am using this code, it isnt working.
Dim db As DAO.Database
Set db = CurrentDb()
db.Execute "INSERT INTO tblPayment ([CurrentBal]) Values (" & NewData & ""
Set db = Nothing

i have this in the CurrentBal controlsource =([Rate]*[Numcalls])

When working with subforms, how does one do this? I assumed it was the same as a regular form. <i know what happens when you assume> = )

It is driving me nuts.

THanks
RAVEN