Trouble being able to input data in fields on form

[hawkdan]

I apologize for my rawness, but I use a linked access application/database for scheduling and scoring cheerleading competitions. I have been able to make everything work, but I have a form for scoring day 2 at events that I cannot input data into the fields. I have solved this issue on a previous form, and recall that it was a simple fix, but I can not for the life of me remember how I did it previously. I have checked every option I can think of versus a working form, and all the properties are the same. Any direction on how I can effect the input fields in a form outside of the property sheet would be appreciated. Thanks.

[June7]

You confirmed AllowEdits property is Yes?

What is the form's RecordSource - table or query? If query, what is the SQL statement?

[hawkdan]

Allow edits is yes. Attached is a screen shot of my query for the form.

[June7]

Looks like a non-normalized data structure. Six tables for scores should probably be one table.

Usually a form can do data entry/edit for only 1 table. What table is target of this form?

I suspect the query is not editable, which means the form based on query would not allow data edits. I don't know your db so can't really advise how to modify the query. Simplify the query until it allows edits.

I REALLY don't like compound keys but should not be an issue.

[CJ_London]

see if changing your form recordset type to dynaset inconsistent updates solves the problem. If not then as June says - the query is too complex to be edited