Hi Ken,
I don't know if this will be of any help but the syntax is this:

Insert Into YourTable(FieldName1,FieldName2,FieldName3) ;
Values('String',Variable,ThisForm.Property.Value)

Cheers
Rob