I have a main form (which is based on the 'Consol' Table) with a button that when pressed, opens another form (which is based on the 'BOL' Table) where the user can enter detailed information.

My problem is this:

I have a field on the main form call Field1. I also have the same field on the detail form with the same name. The field on the detail form is updated via the following:

=[Forms]![Consol]![Field1]

My problem is that the value in the field is not being saved to the 'BOL' table. How can I get the value to be saved?????