Forum Discussion
Refreshing calculated controls
Storming I'm sorry but that's a bit opaque to me. I assume that you mean you want to apply DIFFERENT criteria when requerying those controls later.
In that case, you will have to write different calculations to do that using the filtered recordset. It's hard to know specifically what that might look like because I can't see how that filtering is done. In any event, though, you'll be able to do it from a Public Sub in the subform's code module, which you call in the after update event of whatever controls are being filtered.
If you can provide a sample accdb with only the relevant forms and queries and enough sample data to see how it works, it should be possible to be more helpful.
Hi George, I am just using the built in filtering functions Access provides, i.e. by the drop down arrow to the right of the column header.
Storming I see. That certainly complicates matters then.
There is no connection between the recordsource for the subform and the queries used in the main form. And if the only filtering is on that subform recordsource, it's not clear how you'd actually update them. Again, someone might be able offer up a work around or solution if we could have something to work with....