From one table -> update the fields from other table

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top