Data cannot be entered into subform 2

[Jim Nels]

I read the message from Jae Hood and it sounds like the exact problem I am
having. I have a subform within a form and it was allowing me to enter data
into the subform, but now I'm not getting any blank rows (datasheet view) on
the subform when I click my add new record event. The forms are are based on
a table, and the subform is a junction table. I can go to the table and
enter my data without a problem. I can scroll through the existing records
without a problem. I checked all that you told Jae to, however I do want
Allow Edits to say no, and I had it this way for some time now.

The only think I have done is made some crosstab queries and reports, but
these are based on queries rather than the tables. I do have a query that
uses the table and Group By feature, but that's been there for sometime as
well. I could say that the crosstab queries caused this but my backup from
prior to these reports is acting the same way.

Any clue regarding the missing datasheet in my subform?

 

[Van T. Dinh]

1. If the Subform's RecordSource is a Query / SQL String, check and make
sure the Query is updatable since Queries combining 2 or more Tables may not
be opdatable.

2. Check the AllowAdditions Property of the Form being used as the Subform
(more technically accurate, being used as the SourceObject of the
SubformCONTROL). This needs to be Yes / True

3. Check the Recordset Type of the SourceObject. If it is "Snapshot", you
can't edit or add Record.

4. Check the Enabled and Locked Property of the SubformCONTROL. Enabled
needs to be Yes / True (this should be right as you can scroll) and Locked
False / No.

5. Once all of the above OK, you may need to check similar Properties on
the main Form also. However, most like, the above 4 should fix the problem.