The record source for a form I use is based on a query, which has
several layers of subqueries with quite a number of joins. Needless to
say this record source is not updateble. However, the data nonetheless
must be updated so in my form I have code that manually makes the
changes using VBA. That part works. My problem is that the changes do
not get reflected in the form, presumably because whatever it is that
makes a query not updatable also prevents changes to the underlying data
from being propagated to the current views of the data. While in theory
using a requery command would be appropriate there are a couple of
problems I face:
1. The query takes a few minutes to load. There are normally about 200
records in a given recordset. Needless to say people would not want to
deal with this.
2. The query takes a parameter, which I have found has to be reentered
each time the query is run, even when using the requery command in VBA.
One possible solution would be to denormalize to the first nominal form.
This would be somewhat of a last resort. I was hoping to just be able
to requery a given record without having to reload the entire query.
My searches of Google have proven less than fruitful. I would
appreciate any points anyone might have on this.
several layers of subqueries with quite a number of joins. Needless to
say this record source is not updateble. However, the data nonetheless
must be updated so in my form I have code that manually makes the
changes using VBA. That part works. My problem is that the changes do
not get reflected in the form, presumably because whatever it is that
makes a query not updatable also prevents changes to the underlying data
from being propagated to the current views of the data. While in theory
using a requery command would be appropriate there are a couple of
problems I face:
1. The query takes a few minutes to load. There are normally about 200
records in a given recordset. Needless to say people would not want to
deal with this.
2. The query takes a parameter, which I have found has to be reentered
each time the query is run, even when using the requery command in VBA.
One possible solution would be to denormalize to the first nominal form.
This would be somewhat of a last resort. I was hoping to just be able
to requery a given record without having to reload the entire query.
My searches of Google have proven less than fruitful. I would
appreciate any points anyone might have on this.