J
JimS
I have a form whose RecordSource is a query. The query flattens a
header-detail structure, pretty simple. The query appeared updateable, I
could change quantities, etc. on the form. I recently changed the query to
add a couple of calculated columns and join to a summary query. The new query
is not updateable.
Which of the changes made it updateable? The calculated columns? The join to
a summary query? I want this query to be updateable, and I can sacrifice one
of the two. I'm hoping it's the join to the summary query that made it that
way.
header-detail structure, pretty simple. The query appeared updateable, I
could change quantities, etc. on the form. I recently changed the query to
add a couple of calculated columns and join to a summary query. The new query
is not updateable.
Which of the changes made it updateable? The calculated columns? The join to
a summary query? I want this query to be updateable, and I can sacrifice one
of the two. I'm hoping it's the join to the summary query that made it that
way.