Trying to set up a flter query on two combo boxes 1

[Greg553]

Hello
I am trying to set up a query which is filtered based on selections in two different combo boxes. Can this be done.

Cbo_Weeks
Cbo_Program

the query contains these two fields in the query with other fields also.
The form which contains the Combos is name Frm_PowerTraining

I am trying to filter down so the query only contains info on these two choices.
CBO_weeks has week1 - week 12 ( WK_ID 1,2,3, etc
Cbo_Program has Program_ID 1,2,3

1=strength
2=total
3=hypertrphy

I tried entering it in criteria but nothing happens.
trying to figure what i did wrong

 

[randy700]

You want something like this?

SELECT * FROM [i]YourTable[/i]
WHERE [i]WeeksField[/i] = Forms!frm_PowerTraining.cbo_Weeks
AND [I]ProgramField[/i] = Forms!frm_PowerTraining.cbo_Program

Randy

 

[Greg553]

Thanks, that was easy