copy data from one subform to another

  • Thread starter Thread starter Simon
  • Start date Start date
S

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
 
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 :)
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top