Copy datas

[samtaw via AccessMonster.com]

Hi, I have a main form and two subforms. I want to copy data from one subform
to other with a button. I can only copy one record at a time "me.form...= me..
.". The subform consists of five rows and columns, i want to copy all five
rows and column. I tried Append Query...

Thank you in advance

 

[Duane Hookom]

Append queries are the most efficient method. Subform records can generally
be described with some syntax in SQL. Use this SQL syntax as the base for an
append query.

Your statement "I tried Append Query..." isn't adequate for anyone to
provide much assistance.