Allow Additions not consistent

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

briank - 24 May 2007 16:27 GMT

I have a form that is based on a query that is based on one table. When I
pull up the query I can add records. When I pull up the form I can add
records. However, when this same form is entered into another form (thus
I'll call it a subform) I cannot enter add records. I can view existing
records but the >* button is greyed out.

Allow Additions = Y
Data Entry = N
Allow Edits = Y

Any ideas of why I cannot use this subform to add new records?

Reply to this Message

Dirk Goldgar - 24 May 2007 16:55 GMT

> I have a form that is based on a query that is based on one table.
> When I pull up the query I can add records. When I pull up the form
[quoted text clipped - 7 lines]
>
> Any ideas of why I cannot use this subform to add new records?

Does the main form allow edits? If not, the subform control will be
considered read-only.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

briank - 24 May 2007 17:31 GMT

Dirk,
Thanks for the feedback. Like you suspected the problem was that my main
form did not allow edits. Now it works perfectly.

> > I have a form that is based on a query that is based on one table.
> > When I pull up the query I can add records. When I pull up the form
[quoted text clipped - 10 lines]
> Does the main form allow edits? If not, the subform control will be
> considered read-only.

Reply to this Message