Currect syntax for ApplyFilter command in Subform

  • Thread starter Thread starter RickSF
  • Start date Start date
R

RickSF

I have a form containing a subform that I want to filter for specific records
when I open the main form via a macro. The Control Source for the Subform is
a query called: BudSpendDetail0QTr that contains the two fields CashFlowMM
and CurrMMYY.

The syntax in the Where condition is:
[Forms]![BudSpendTransit]![BudSpendTransitSub
Subform].[Form]![BudSpendDetail0QTr]![CashFlowMM]=[CurrMMYY]

The result I get is not for the current month (example 01/10) but the prior
month (12/09).

The subform is not linked to the main form, so I leave the Fiter Name blank.
(Otherwise, the condition goes into the properties of the main form, and I
get errors becasue the fields in the query are not in the main form's control
source.)

What is the correct syntax to filter the query that controls the subform?
 
Rick -

What do you get if you just run the query BudSpendDetail0QTr? The criteria
you have would only restrict this set to where the CurrMMYY = CashFlowMM. Is
the CurrMMYY in the query pulling the current month/year dynamically, and is
it correct?
 
Back
Top