Combo box as a criteria for a crosstab query.

[Frank Martin]

I have a popup form (FrmCustSalesPopup) with a ComboBox (Combo1) designed to
display sales, via a pushbutton, for any particular customer selected in
Combo1 from the crosstab query "QryCustSalesCrosstab".

I must be doing something wrong because when I use the parameter
"Forms!FrmCustSalesPopup!Combo1" I get no result.

Also, is there a way of doing this with the VBA code
from the pushbutton on the popup form to save
using the query parameter expression.

Please help, Frank

 

[Tim Cali]

This occurred to me and the solution was that the criterion must also go
into the Query Parameters. In the query's design mode -> Query menu ->
Parameters -> type it in under "Parameters".

Don't know about your VBA question.