Cannot Edit Form

[Derrick T. Davidson]

I have a query that matches supplier selected [tblPickSupplier] with suppliers table [tblSuppliers]. The query loads the correct form but I can not Edit the form, I have ensured there are no unique values in the query properties but the form is displayed but uneditable? What am I doing wrong?

[RuralGuy]

See if there is anything in this link that rings a bell: http://allenbrowne.com/ser-61.html

[Derrick T. Davidson]

I cant see anything obvious here is a screen shot of my query?

[RuralGuy]

Show the SQL view of the query, please.

[Derrick T. Davidson]

SELECT tblSuppliers.[SupID], tblSuppliers.[SupSupplier], tblSuppliers.[SupSal], tblSuppliers.[SupFirstName], tblSuppliers.[SupMI], tblSuppliers.[SupLastName], tblSuppliers.[SupSuffix], tblSuppliers.[SupNickName], tblSuppliers.[SupJobTitle], tblSuppliers.[SupGender], tblSuppliers.[SupAddress1], tblSuppliers.[SupAddress2], tblSuppliers.[SupBarangay], tblSuppliers.[SupCity], tblSuppliers.[SupProvince], tblSuppliers.[SupRegion], tblSuppliers.[SupPostCode], tblSuppliers.[SupCountry], tblSuppliers.[SupPhone], tblSuppliers.[SupFax], tblSuppliers.[SupCellPhone], tblSuppliers.[SupE-mail], tblSuppliers.[SupNotes], tblSuppliers.[SupTIN], tblSuppliers.[SupVAT]
FROM tblSuppliers INNER JOIN tblPickEditAddSupplier ON tblSuppliers.SupSupplier = tblPickEditAddSupplier.EdSupSupplier;

[RuralGuy]

Could this line apply?
The fields in a JOIN are not indexed correctly: there is no primary key or unique index on the JOINed fields.

[Derrick T. Davidson]

Git it thanks changed the linked fields and no problem. Thank you for your help.

[RuralGuy]

Excellent! Glad we could help.