Subform Not Allowing Data Entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray Moon - 10 Oct 2005 14:52 GMT

All,

I have a subform. The subform's data source is a query that is based upon
two fields in the parent form. When the parent form is run, even the blank
new record line is not displayed. I entered a set of data manually. This
data was displayed but could not be edited. I checked the subform field in
the parent form. Its properties were: Enabled - yes and Locked - no. I check
the subform itself, the detail section, and each of the individual fields in
the subform. Their Enabled and Locked properties were set the same way.
Within the subform the Allow Edits, Allow Additions and Allow Deletions
properties were set to yes. The Data Entry property was set to no.

I have searched Microsoft's TechNet but to no avail. Any help would be
appreciated greatly. Thanks in advance.

Ray

Reply to this Message

Jeff Boyce - 10 Oct 2005 14:57 GMT

Ray

Unless I misunderstood, I believe you posted the answer to your question...

"The Data Entry property was set to no."

If the form can't have data entered, you won't see the 'add new record'
line.

If the data can't be edited, perhaps the underlying query is not an
updateable record set?

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> All,
>
[quoted text clipped - 12 lines]
>
> Ray

Reply to this Message

Ray Moon - 10 Oct 2005 23:11 GMT

Jeff,

Thanks for the response. When looking up the definition of DataEntry, when set to False (default), the form opens showing existing records and when set to true, the form opens showing only a blank record. The DataEntry property has an effect only when the Allow Additions property is set to Yes. This, I believe, is the property that the addition of new records. This would not explain why I can not edit an existing record.

As for the underlying query is not an updateable record set, I can open the query directly and edit existing records and add new records.

I did go back to review all of the properties. I finally notice that on the basic form, had the Allow Edits, Allow Additions and Allow Deletions was set to false. Therefore, I have found the enemy, and he is I.

Thanks again for time you spend to help me.

Ray

> Ray
>
[quoted text clipped - 26 lines]
>>
>> Ray

Reply to this Message

Jeff Boyce - 11 Oct 2005 01:42 GMT

Ray

Sorry for the mis-lead, and glad you found it. I get to add that to my
"learn something new each day" list!

Regards

Jeff Boyce
<Office/Access MVP>
Jeff,

Thanks for the response. When looking up the definition of DataEntry, when
set to False (default), the form opens showing existing records and when
set to true, the form opens showing only a blank record. The DataEntry
property has an effect only when the Allow Additions property is set to Yes.
This, I believe, is the property that the addition of new records. This
would not explain why I can not edit an existing record.

As for the underlying query is not an updateable record set, I can open the
query directly and edit existing records and add new records.

I did go back to review all of the properties. I finally notice that on the
basic form, had the Allow Edits, Allow Additions and Allow Deletions was set
to false. Therefore, I have found the enemy, and he is I.

Thanks again for time you spend to help me.

Ray

> Ray
>
[quoted text clipped - 26 lines]
>>
>> Ray

Reply to this Message