Design problem?

[Patttt]

Is there a reason why a subform won't let you enter new data? I can enter new
data in the main form section just fine. The subform does have the dropdown
list that displays the correct choices, but when I click on one of them,
nothing is entered in the field. Essentially, the subform only displays the
existing data but won't let you enter new records. The tables ARE related, so
it's not a relationship issue. any thoughts? Thanks for your help! Pat

 

[Rick Brandt]

Is there a reason why a subform won't let you enter new data? I can
enter new data in the main form section just fine. The subform does have
the dropdown list that displays the correct choices, but when I click on
one of them, nothing is entered in the field. Essentially, the subform
only displays the existing data but won't let you enter new records. The
tables ARE related, so it's not a relationship issue. any thoughts?
Thanks for your help! Pat

Either your form does not allow edits/inserts or the RecordSource it is
bound to does not. Are you using a query for the form's RecordSource?
Many queries are read only.

 

[Patttt]

I didn't write the original database but am trying to correct a number of
problems in it. As far as I can tell, the form is based on a query that is
based on a table. :} I drilled down and learned that I can enter a new record
in the table but not in the query.

 

[Patttt]

BTW - How do I tell if the query is read only? I don't see anything about it
in the properties section........ thanks!