copy data from one subform to another

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
 
S

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

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

Similar Threads

How to copy files from Onedrive account to another 2
how to pass data from subform to another subform? 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
Adding data to Subform and save and running a total price calc 0
Designate font as italic of another 0
Sharepoint not capturing staff name when automation runs 0
Looking up mulitiples items 1
how to pass data from pop up form 1

Top