Combo box as criteria

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Is it possible to use a combo box to select criteria when
opening a query?

For instance, I now have a criteria of [Enter Product] so
when I open the query I have to type in a product name.
However, I would like to be able to select a product name
from a combo box.

Is this possible?
 
Hi,
You have to use a form for this.
In your query you would use Forms!yourForm!yourCombo
as criteria.
You could have a button on the form that would then open the query.

HTH
Dan Artuso, MVP
 
Back
Top