run-time error 2448 - update using me.name

[lazynewt]

- I have a query that checks 2 tablles and if the records email address in tableA match the addresses in tableb then it returns name,address,area,postcode,emailattribute of the records to a form.
- the form on open event is

Private Sub Form_Open(Cancel As Integer)
Me.emailattribute = "1"

End Sub

This produce a list of records and all of them should have the emailattribute as "1". But i am getting the above error.

- form is not read only
- form is not open in design view
- value is deffo not too long.

Im stumped. Is this because its pulling it from a query ?

thanks in advance for any help.

====================edit=======

Heres the original query

SELECT Customers.name, Customers.ContactFirstName, Customers.ContactLastName, Customers.Address, Customers.Area, Customers.[Town/City], Customers.County, Customers.PostalCode, Customers.emailattribute
FROM Customers INNER JOIN emailaddresses ON Customers.[Email Address] = emailaddresses.[email address];

 

[lazynewt]

Ok I figured i should be using

Private Sub form_load(Cancel As Integer)
Me.emailattribute = "1"
End Sub

instead but this only inputs 1 into the first record. i am trying to get it to imput 1 into every record the query returns....