editing data in a subform

  • Thread starter Thread starter Patti
  • Start date Start date
P

Patti

I have a form with a subform where the CompanyID is linked
together. There's a set number of records for each
company in the subform and I'm trying to change or update
a value in one of the fields in the subform, but it won't
allow me to do so. If I go back to the table, I can make
the change, but not in the form. Any suggestions???
 
Do you have a query between the table and the subform? If so, can you edit
the field from the query?
 
I do have a query between the table and the subform. I
cannot edit from the query, either.
 
In that case, it sounds as if the query is not updateable. Can you post the
SQL of the query?
 
I was trying to use this query for more than one
report/form, etc. Evidentally had too much data in it, so
I created a new query for this subform by deleting out the
unneccesary fields from the original query, and it seems
to work. Thanks for getting me thinking in the right
direction!
Patti
 
I created a new query. I was trying to use the same query
for several reports/forms, etc. and evidentally had too
many unnecessary fields for this particular form. I made
a new query with just the fields that I needed, and I am
now able to edit data. Thanks for getting me thinking in
the right direction!

Patti
 
Back
Top