I have a new queried report that takes the PRODUCT table inner-joined with a
CrossTab query, CT_ZONE_PRICE. Im having trouble with a form that the user
can choose only their regional ZONE & get only their columnized regional
pricing.

I can do this by 1st manually filtering the field named [ZONE] in the
ZONE_PRICE Query that the CT_ZONE_PRICE is CrossTab queried from. Then run
the macros to create the reports. I tried with Form filter €œLike
[Forms]![ZONE_PRICE_ Form]![ZONE]€� within the ZONE_PRICE Query & also with a
ApplyFilter in a macro, €œWHERE ((([ZONES].ZONE) Like [Forms]![ZONE_PRICE_
Form]![ZONE]))€�.


The SALES_REPORTS form below works for a simple query report.
This form has several combo boxes where a user can choose the filtering
criteria for their reports. This form runs great with the following DoCmd.

Private Sub Command6_Click()
Me.Visible = False
DoCmd.OpenQuery "MT_PROD_SALES", acViewNormal, acEdit
DoCmd.Close acForm, "SALES_REPORTS"
DoCmd.RunMacro "SALES_Macro"

End Sub
--
Thanks, Kevin