ms/access subform update with refresh/requery
Posted on 2016-11-12
I am facing a challenge with a special subform that I have developed - it does not update to the query to which is bounded.
On the masterform I have some fields that, upon being filled/updated, do generate a set of two sequential queries, the second one being bounded to the subform.
On masterform load everything works fine and the queries based on the updated fields are ran and output RST is what is expected. However, in the subform, only the original RST is shown. I have Me.refresh / Me.Recalc whenever I update the fields and run the queries. But I do not know to to force the subform refres/recalc/requery (if that is the solution)
can anyone help?