From one table -> update the fields from other table

G

Guest

Hell

I have a form who have 10 fields from TABLE1 that after make calculations with them
i build the field M1 from TABLE

The event that fires those calculations is AFTER UPDATE field D

How can i update the TABLE2 - field M1 ?

the tables are
TPavimentos
TMomento

Form FrmCalcul

Table to be updated TMomento
Field to be update M
 
M

Michel Walsh

HI,


Which record specifically?


CurrentDb.Execute "UPDATE table2 SET m1=" & NumericalValue & "
WHERE pk=" & primaryKeyValueSpecifyingTHErecordToUpdate



If values are not numerical, use the appropriate delimiters.

Hoping it may help,
Vanderghast, Access MVP
 

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

Have both records from two queries/tables under one Query without related fields. 0
Updating one table from another table 4
INSERT / UPDATE Query in same operation 2
DSum update query with multiple fields 0
Query on two tables with matching null fields 4
Use Update Query to Add Fields 1
copy values from one table to another 3
Updating one tables value based on another table 1

Top