Adding records by clicking on a button

H

hin87_at_yahoo.com

Hi,

How can I adds records from clicking a button?

Here what's I'm trying to do.

Table:
ShoppingCart: ID, Name, Price
ex: 1, forks, $4
2, spoons, $3
3, water, $1

Table:
Order: ID, ItemID, Name, Price

If I click on a button, how can I put these items into the Order table
and refresh the Order form to show the items ?


Thanks,
 
V

Van T. Dinh

Use Append Query.

In code, you can use the OpenQuery Method to run the Query or RunSQL Method
to run the SQL String. However, the preferred method is to use the Execute
Method.

Check Access Help / Access VB Help on above terms.
 
Top