By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 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.
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
Nov 20 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 20 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.