changing criteria automatically

[John thomas]

In a quirie is it posible to change the criteria in one field by the use of a combo box or similer

 

[Mr. B]

You can use the name of a combo box on a form as the criteria for your query. Then what you selected from the combo box will be used as the criteria for your query.

 

[Pat Hartman]

So the criteria would look something like:
Select ....
From ...
Where SomeField = Forms!yourform!somecontrol