Delete record data in Form and append data in table

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hello!

I have:
1 - T_Leaders, T_MemberTeam. Relationships: One to many
with IdLeader. 3td table T_Historic, One to many with
IDLeader too;
2 - F_Leaders with SubF_MemberTeam.
I need delete any MemberTeam record and append our data
into table T_Historic, with command button in
SubF_MemberTeam. I don't know how.
Thanks in advance.
an
 
Many thanks for your help.
an
-----Original Message-----
You could do this by executing an Append query statement, followed by a
Delete query statement.

More information:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
Back
Top