By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,894 Members | 2,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,894 IT Pros & Developers. It's quick & easy.

Can't update a recordset after filtering

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

P: n/a
Its OK, I have found the problem. Thanks for your help.

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.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.