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
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