Updating checkbox in table with query

[BatmanMR287]

I need to update a checkbox in a core table from a temp table. How can this be done?

[June7]

Why using temp table?

Build a query that joins the two table on the common identifier fields. Switch to UPDATE query, set the UPDATE TO row under the destination field with the source table/field.

[BatmanMR287]

Temp table is a buffer for data entry. Didn't want data entry form directly connected to table. Also needed to pull two pieces of conformation information to temp table to display on data entry form.
Wasn't used to update queries but am more so now. I set the update with the location I wanted to update, did [Forms]!["current form name']!["location on form where information is'] and for criteria did the same [Forms] script so the update knew which policy number to apply checkbox update to. Worked great. \
Done with all forms, queries and macros. Now on to a detailed report with detailed criteria!