Combo box as a criteria for a crosstab query.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

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
 
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.
 
Back
Top