Allow Additions not consistent

G

Guest

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?
 
D

Dirk Goldgar

In
briank said:
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?

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top