Editing Subform Data

[tylerg11]

I am trying to edit the fields in a subform, but it is not working. I checked all the property settings, and found out that the fields I want to edit were locked. I unlocked them, and verified the other properties. I still can't edit the subform values. I can edit the values in the table, and the query...no problems there. I just can't do it in the subform! If I edit the values in the source query, I can view the changes in the subform, but can't actually make the changes from the subform.

[boblarson]

1. Is the main form's Allow Edits property set to YES?
2. Is the subform's Allow Edits property set to YES?
3. Are the master/child links set up properly?

[tylerg11]

Yes, that is all correct. The master/child links are correct. I have a dropdown box where the companycode can be selected. This populates the subform with contact details. So the companycode field is the connector field.

[boblarson]

Yes, that is all correct. The master/child links are correct. I have a dropdown box where the companycode can be selected. This populates the subform with contact details. So the companycode field is the connector field.

Please clarify - you have combo box on the main form. You select a companycode. So, what does it do then? Are you saying that you have code to populate the subform with details for that company? If so, you shouldn't be storing the company details again so we should also address that when we can. Or do you have a control source for the controls which DISPLAYS, but not saves, the company information by usng something like
=[Form]![FormNameHere]![ComboName].[Column](1)

[tylerg11]

Thanks for the help. I just got it figured out. The fields weren't locked, but the subform was. By using the form selector, I couldn't see that property. Once I selected the subform with the orange frame, I did. That solved it. Just a quirky little Access thing.