Does anybody know the insert into statement in SQL that will copy a record from one file to another if the primary key value is known on an open form. At the moment I have
INSERT INTO [kpi copy]
SELECT *
FROM kpi
WHERE [id]=827;
This does not take me far enough to be able to copy a record from an active form and press a button.
INSERT INTO [kpi copy]
SELECT *
FROM kpi
WHERE [id]=827;
This does not take me far enough to be able to copy a record from an active form and press a button.
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
