Unanswered: Change parameters in a subquery using VBA
Thanks for reading my post!
I have a 4 subquery series built up, all left joins so all invoices from tblinvoices are returned-
qryMR2/customer invoices with payments
qryMR3/customer invoices with payments that have been purged
qryMR4/a sums query by customer = customer number and 5 sum fields
qryMR4 is record source for a subreport
The subreport is used in different main reports that have date, age, value criteria which I have written with VBA querydefs.
I need my subreport to match the main report querydefs, except, since it is a sum query, the field I need in my where clause is in QryMR3
How can I write VBA querydef to execute qryMR3 where clause so that it is the resulting qryMR4 I need when the main report opens???