How to update set of records (ADP)?

  • Thread starter Thread starter lemes_m
  • Start date Start date
L

lemes_m

Hi all!

I have table "Orders" and also "OrdersDetails" which are related with
field "OrderId". After user enters all data I need to update field
"AvgPrice" in "OrdersDetails" from VBA code after I do some
calculations. I supose it can be done with FOR EACH Statement but I
can't get it work.

Anyone knows the solution?

Regards,

Mirnes Lemes
 
Use the DoCmd.RunSQL command, something like this:

DoCmd.RunSQL "UPDATE OrderDetails SET AvgPrice=" &
your_calculated_new_average & " WHERE OrderID=" & your_order_id
 
You must log in or register to reply here.

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

HELP NEEDED ASAP - Updating table row by row (ADP) 3
Why SP doesn't execute? (Urgent) 1
Copying Records 3
Generating a collection from a data set table 2
Question abt delete qry! 3
how to create new record automatically 2
ADP Form won't save data in Access 2003? 2
Getting records from a Memo 1

Back
Top