Query By Form

Hello guys

I have a question that's probably a beginers one but i looked all over the forum and the examples and couldnt find any solution. If you could help it would be great. Here we go:

Lets say we have 1 form, a table and a query. On the form there is a combo box named combofield with values 1, 2 and 3. Table has this fields:

name
f1
f2
f3

query looks like this:

field from some other table 1
field from some other table 2
name
f1

What i need to do is when i chose 2 from combo box and press some button is to get this query:

field from some other table 1
field from some other table 2
name
f2

and same thing for value 3 from combo box

field from some other table 1
field from some other table 2
name
f3

I know i could just make 3 queries and just pick one based on the values in the combo but in reality i have some 15 fields that i need to chose from.

Tnx in advance