Hello every one
i have two tables
now how can i add the recid and userid in table number two
(by the way relations has been set and this is the command i am using)
DoCmd.RunSQL "insert into attempts(recid,lastsignon,un,mn) values('" & Me.recid.Value ','"&now()&"','"&un()&"','"&mn()&"')"
but i am getting erro revery time i try to run it
the reason is instead of every time sending the login data in to the same table i want to send in to seperate table it is easier this way to keep track of every one
here is my code