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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIf statement in query criteria 5
criteria failure 7
Query with Combo Boxes on a Form 1
Show all records with a keyword ex:"ALL" 3
crosstab parameterized query 1
Multiple Parameter Crosstab query filter by form 1
Query criteria problem !!!! Please help 1
parameter query 1

Back
Top