Subform not enterable

[Robert]

I cannot enter data on a subform. The form is enabled and not locked and
the fields are enabled and not locked. Allow additions and allow edits are
both yes. Data entry is no. The main form on which the subform resides is
okay / allows entries.

This subform is bound to a saved query which has 2 queries in it. Could
that be why it won't allow data to be entered? If not, any other ideas?
Would it be worth my while to try recreating it? How about binding the form
to one table and using dlookups on the fields?

Robert

 

[John W. Vinson]

This subform is bound to a saved query which has 2 queries in it. Could
that be why it won't allow data to be entered? If not, any other ideas?
Would it be worth my while to try recreating it? How about binding the form
to one table and using dlookups on the fields?

Some multitable queries are updateable, and some aren't. Are you trying to
update both tables or only one of them? Could you perhaps post the SQL of the
query (or queries)? Are any of the queries Totals queries or unique-values
queries - if so they cannot be updated.

John W. Vinson [MVP]

 

[ruralguy via AccessMonster.com]

I cannot enter data on a subform. The form is enabled and not locked and
the fields are enabled and not locked. Allow additions and allow edits are
both yes. Data entry is no. The main form on which the subform resides is
okay / allows entries.

This subform is bound to a saved query which has 2 queries in it. Could
that be why it won't allow data to be entered? If not, any other ideas?
Would it be worth my while to try recreating it? How about binding the form
to one table and using dlookups on the fields?

Robert

MVP Allen Browne has a good description of why queries are read only at this
link:
http://allenbrowne.com/ser-61.html