Update field on table, with value from 2nd table from form

I have two tables and a form:
Table 1
Id products pkg size customer addr city state zip

Table 2 (set up as query)
Id product pkg size

Form 1
Has same fields as table 1 and was originally built from that table.
However…I made some changes so the user can enter some things and allow some
fields to default based upon entry of other fields.
Product is a ComboBox that has dropdown of ‘products’ from table 2. When I
select the product it ‘automatically’ fills in the TextBox ‘pkg size’ on the
form. However…it does not update Table 1 like all the other fields.

My ComboBox ‘products’ on the form is set up:
Control Source Products
Row Source qryTable2
Row Source Type Table/Query

My TextBox ‘pkg size’ on the form is set up:
Control Source =[Products].[Column](2)

I can go back into my form, and the ‘pkg size’ is there, but not on Table 1…..
but everything else I enter on my form is there???

Why doesn’t the pkgsize update on Table1 ???

I’ve tried events…AfterUpdate…
Ie; DoCmd.RunSQL "UPDATE [Table1] Set[pkgsize] ='" [Products].[Column](2)
"'"