Form input into query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: George (anonymous_at_discussions.microsoft.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 06:11:06 -0700

I have a query that works fine, but I would like to generalize it so that a form can provide the parameters for the query. I have put the "Where" criteria in the query and set the criteria to be the form object (a combo box). When I open the form, and select the criteria from the combo box, I click a button to open the query. However, the query still prompts for the value instead of reading it from the form.

Any ideas?

Thanks

Quantcast