Query runs when a policy number is input in a form

[AmyLynnHill]

I have a form set up and would like to have field update to a table when a policy number is input into the form. The fields are extracted from a linked table and are not viewed on the form but need to be written to a table to create a report. I'm confused on the sets to take to handle this. I think i need to use the "onchange" property and set up a macro that runs a query but how does the query write to the table?

 

[llkhoutx]

Two ways to do this:

(1) Use an linked subform which makes the requisite update; and
(2) Use ADO/DAO code to update the requisite recordset on the 'field" AfterUpdate event.

Check data quality with the second method.