Record Written to Table when a field is updated

[AmyLynnHill]

Does anyone know how to have the information input into a form written to the table once a specific field is updated? Rather than once a new record is input?

 

[rainman89]

in the afterupdate of the box you can do a

docmd.RunCommand acCmdSaveRecordcommand

... but why would u want it to save for just that entry box?

 

[AmyLynnHill]

After the user input the information a button is pushed to extract additional information (based policy number)from a linked table to a datawarehouse. The infomation put into the form and the DW information creates a report that gets e-mailed.

 

[rainman89]

Ah ok. makes sense

 

[AmyLynnHill]

Works like a charm! Thanks