Is it possible to have an Unbound ComboBox where the source record is a CrossTab Query? I’m having trouble with a form. The form is for the user to choose only their regional ZONE & get a report of only their columnized regional pricing.

I can filter criteria manually within the CrossTab Query: WHERE ((([Competitors - CLP].ZONE)="BILL")). Then I changed it for the form to: WHERE ((([Competitors - CLP].ZONE) Like [Forms]![ZONE REPORTS Form]![ZONE])).

The following SQL works without the form.
TRANSFORM First([Competitors - CLP].[PRICE TEXT]) AS [FirstOfPRICE TEXT] SELECT [Competitors - CLP].ITEMNO FROM [Competitors - CLP]
WHERE ((([Competitors - CLP].ZONE)="BILL"))
GROUP BY [Competitors - CLP].ITEMNO PIVOT [Competitors - CLP].COMP;

This is similar to a simple query I have that works with the same type of form & the following WHERE criteria: WHERE ((([SALES_DATA].VENDOR) Like [Forms]![SALES_REPORTS]![Vendor]));

This form has a combo box where a user can choose the filtering criteria for their individual 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"