Change a query field with a parameter?

I have a table with 5 different fields.
ID
Field Name = This field refers to land not a field in access.
2007 Crop
2008 Crop
2009 Crop

I now have a query that just gives me "Field Name" and "2009 Crop" and
I want to have a form with a combo box so that I can change the query
to select ether "2007 Crop", "2008 Crop" or "2009 Crop"

Is it possible to with a combo box change my query?
Thanks
Clarence

re: Change a query field with a parameter?

Clarence,

Allen Browne has some GREAT code to do this for a report, plus a very
nice explanation of how everything works here:

http://allenbrowne.com/ser-50.html


I just used it yesterday, and it's sweet.

You could modify it easily to run a query instead of a report.

Thanks Alan!

Patrick