By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,731 Members | 1,720 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,731 IT Pros & Developers. It's quick & easy.

Change a query field with a parameter?

P: n/a
I have a table with 5 different fields.
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?
Nov 20 '08 #1
Share this Question
Share on Google+
1 Reply

P: n/a

Allen Browne has some GREAT code to do this for a report, plus a very
nice explanation of how everything works here:
I just used it yesterday, and it's sweet.

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

Thanks Alan!

Nov 20 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.