how to use table triggerd after update macro

[maramadan]

Hello Access experts
hope you are having a good day

please help me with this
I have two tables

I want to make a date macro, when I make changes to table1.num1 changes reflect on table2 by creating new record
TABLE1 have three fields ID, Name1, Num1
TABLE2 have three fields ID, Name2, Num2
the after update table macro lock like this in table1
If Updated([num1])
create a record in Table2
SetField
Name table2.ID
Value = [table1].[ID]
SetField
Name table2.name2
Value = [table1].[name1]
SetField
Name table2.num2
Value = [table1].[num1]

Why it is not working

thanks

 

[bob fitz]

Cross-posted: https://access-programmers.co.uk/forums/showthread.php?t=297048

Please read: https://www.excelguru.ca/content.php?184

 

[Ranman256]

all you need to is run an append query.
this copies the data entered to table2.

 

[arnelgp]

fist, Updated() function accepts String parameter,
so you will have to change that to:

If Updated("num1")


second, make sure that ID field in Table2 is
not set as AutoNumber, othwerwise it won't
save the ID from table1.

 

[isladogs]

Cross-posted: https://access-programmers.co.uk/forums/showthread.php?t=297048

Please read: https://www.excelguru.ca/content.php?184

Hi bob

You've linked this thread to itself... easily done!

 

[bob fitz]

Hi bob

You've linked this thread to itself... easily done!

Ooops. Should be: http://www.accessforums.net/showthread.php?t=69198

Thanks Colin

 

[isladogs]

No problems. I've done it myself when posting similar info on both forums.