Form does not accept data

[bongo]

I've created a form based on a query, which in turn is based on 3 tables and another query. The tables are populated with data. Problem I have is that the form does not accept data inputs - the field property sheet has enabled set to 'yes' and lock set to 'no'. Furthermore the relationships between the 3 tables and query are one to one with referential integrity enforced. So why does the form not accept data edits?



Thanks for any help.

[RuralGuy]

Sounds like your query is not updateable.

[bongo]

Thanks RuralGuy, my queries had Sum fields making them not updatable.

[RuralGuy]

Bingo! You catch on quick and you're welcome.