Form Field won't update two different tables

[dbmondo]

I have a from field that I added to a form. All other fields in this form
are linked to Table 1 (the form was created to fill Table 1) but this new
field needs to update Table 2. I have the field linked correctly as I can
see but it does not appear to be working any ideas as to why?

 

[Klatuu]

First, it is not a field, it is a control. Only tables and queries have
fields. Forms and Reports have controls and controls can be bound to fields
in the form's recordset. This is the problem you are having. The control
you are using cannot be bound to a field not in the form's recordset.

It may be possible for you to use a query that includes the field from
table2 provided there is a way to relate the two tables; however, in some
cases a query is not editable. That depends on the relationship of the
tables.

Another solution would be to create a subform and use table2 as its record
source to make the field available.