Incorrect value appearing

[99mel]

I have a subform which I simply use to insert a new record into a table. I want one of the fields on this subform to contain a value from a field on the main form. I have done this by setting the default value to the field which i want.

However... this field (textbox) on the subform gets populated with the correct value but when I actually insert a record by entering in another field it changes the value of this field.

The table has no default values set up on this field so I'm wondering if theres any other event which is firing off when I insert this record.

 

[dakota81]

Instead of setting the default value, set the control source?

 

[99mel]

the control source is linked to the field in the table