code for copy filed from table to another

[qupe]

i made a form with check filed
i want if i check this filed it copy filed from table1 to new record in table2

i made like this

Private Sub track_BeforeUpdate(Cancel As Integer)

If Me.track.Value = True Then
Database.Form_Mtable.Watched.Value =


End Sub

any advice plz

 

[Guus2005]

I am sorry but you're not making any sense.
Please rephrase the question.

 

[qupe]

I am sorry but you're not making any sense.
Please rephrase the question.

Ok

i have a data base with two table one call mtable another call track and both are related .
and both have field with name watched
there is also in mtable a field with check box call track-it

i want if i check this filed the vba code will copy data value from mtable to track table

the problem that i had worked with excl but i cannot get it in access

so i tried this code but as you see it is nothing

so i appreciate any help

 

[Guus2005]

Copying data from one table to another is not the solution to any problem in a relational database environment. Because of redundancy.
You are describing how you want to fix a problem, but what is the actual problem? Why would you want to do that?

You may also want to reread before you post and pls don't use abbreviations. English is not my native language and i may not understand what you mean.