Help with 'Criteria' code in query results

[shocktea]

I have a very simple cascading combo box form with three combo boxes.
First - Customer - pulled from tbl1
Second - Item Description - pulled from tbl1, based on Customer
Third - Quarter - not pulled from any table, just 1-4 numbers I manually inputted

The cascading part works perfectly fine, but the problem comes with the query button to get the full report I need. If someone selects quarter 1, I want the query to pull up only the quarter 1 column in the table for that customer and description, not quarter 2, 3, 4 columns too (those should just be invisible).

(This part works fine) In the query under Criteria, I have placed:
Customer -- [Forms]![frmSummary]![CBCustomer]
Item Description -- [Forms]![frmSummary]![CBDescription]

then I have columns Quarter 1 -4 and don't know what code makes the query show only the correct column based on the quarter combo box.

I'm assuming it might look something like..vvv...but I know this is wrong.
Quarter 1 -- [Forms]![frmSummary]![CBQuarter]=1


Help please! I think the solution should be simple

 

[Uncle Gizmo]

I'm not 100 percent sure but I think this post I did a while back my cover it.

http://msaccesshintsandtips.ning.com/profiles/blogs/allow-a-combo-box-to-return

 

[shocktea]

Thanks, I'll check it when I'm on a different network. Work computer is blocking that site even though the Access question is for work! I'll let you know if I have any questions about your previous post.