Creating a query based on a selection

  • Thread starter Thread starter Claus
  • Start date Start date
C

Claus

Hi,
I'm looking for a way to query/display all datasets that meet a
criterion. This criterion is one set of data in an existing table. I
want to choose this set of data from a pull-down menu.
In other words, I already have a query designed, but I want to vary the
Criteria (in design view) through a pull down menu.
How do I do this?

I'm absolutely new to access, so any (basic) help would be really
appreciated (also links to good resources on the net)!

Thanks,
Claus
 
Claus,

In Access, a "pull-down menu" is called a combobox. If the combobox is
on a form, you can refer to it in the criteria of the applicable column
in the query design, using syntax such as this...
[Forms]![NameOfYourForm]![NameOfCombobox]
 
Back
Top