I am writing a software application using ms/access 2010 and VBA. In the main form I have a computed field that is used to filter records on an embedded form.
In the embedded form, I am seeting up a filter select some of the records, depending on the additional calculations.
The problem is that as the embedded form needs to be updated as I change fields in the embedding form. because it is already open there are no events to update it.
I have tried, in the main form to do "Forms![subform].recalc by it tells me that the subform does not exist.
What shall I do?