The query is just on the one table with one criteria which is the calendar
year which is taken from the combo box control. Apart from changing the
recordsource to the filtered on year query, the after update even from the
combo box requeries the form so that all of the subforms can run and get
their data. This is really weird as I can see nothing wrong with any of it,
yet, the error message "This recordset is not updateable" comes up when I
try to copy the results of the subforms to bound text boxes.
dixie
"Salad" <hi**********@ranch.com> wrote in message
news:3F***************@ranch.com...
dixie wrote:
I have a form full of subforms which bring summary information onto the
form from about 12 different tables. I am trying to get all of that summary
information (mainly numbers) into 1 large table that represents the
final results for the year. The table into which I wish to save it has 10
records, the past 10 years results. The problem is that I select the
calendar year from an unbound combo box and it runs a filter that
restricts the records to only that year in an after update event. At that stage,
I have code that will copy the values of each subform into text boxes
which are bound to my table. The theory works if I don't filter the
recordsource query (me.recordsource = "restricting query"), but as soon as I do, the
record source is not updateable and I can't save anything. How do I get
around it?
dixie
Are you sure the recordset is really updateable? Create a query with the
filter for that year with all of the Where criteria.. Open the query. One of
those "criterias: is stopping you from updating the record. Remove them one at
a time till you find out which one. Then fix or adjust.
You may have to Dim a recordset, update the record, then requery if worst
comes to worse.