field write in other table

I created a form, I would have a field that when I insert data do not write on the table in use but in another table, how can I do

in the onaftervalidate event create the insert statement for that specific field.

Regards

[QUOTE=kafecadm;35772]in the onaftervalidate event create the insert statement for that specific field.

Regards[/QUOTE]

but i must write i query for copy value in other field?

yes you have to