copy data from one subform to another

[Simon]

I have a form with two subform

One subform has a list of products that i sell and another of the
products customer are going to purhcase

On the List Products i have a buy button which i need some code for
when this button is pressed it copys the ProductCode from the list of
products to the tblOrderProducts tabel


Hope someone can help


Thanks

 

[strive4peace]

Hi Simon,

you can use an Append query ... what are the fieldnames you want to fill
out in tblOrderProducts ?



Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*